Learning Materials
Features
Discover
Chapter 22: Q12RQ (page 1228)
What are the two types of manufacturing overhead? How do they affect the manufacturing overhead budget calculations?
Variable manufacturing overheadandFixed manufacturing overheadare two types of manufacturing overhead.
Over 30 million students worldwide already upgrade their learning with Vaia!
All the tools & learning materials you need for study success - in one app.
Get started for free
Using Excel for to prepare an operating budeget (manufacturing company)
Download an Excel template for this problem online in MyAccountingLab or athttp://www.pearsonhighered.com/Horngren.
Thunder Creek Company is preparing budgets for the first quarter of 2018. All relevant information is presented on the Excel template.
Requirements
1. Prepare a Sales Budget.
2. Prepare a Production Budget.
3. Prepare a Direct Materials Budget.
4. Prepare a Direct Labor Budget.
5. Prepare a Manufacturing Overhead Budget.
6. Prepare a Cost of Goods Sold Budget
7. Prepare a Selling and Administrative Expense Budget.
Using sensitivity analysis in budgeting
Refer to the Berry’s schedule of cash receipts from customers that you prepared in Short Exercise S22-9. Now assume that Berry’s sales are collected as follows:
60% in the month of the sale
20% in the month after the sale
18% two months after the sale
2% never collected
Prepare a revised schedule of cash receipts for January and February.
Preparing an operating budget—direct materials budget
Bell expects to produce 1,800 units in January and 2,155 units in February. The company budgets 3 pounds per unit of direct materials at a cost of $10 per pound. Indirect materials are insignificant and not considered for budgeting purposes. The balance in the Raw Materials Inventory account (all direct materials) on January 1 is 4,950 pounds. Bell desires the ending balance in Raw Materials Inventory to be 20% of the next month’s direct materials needed for production. Desired ending balance for February is 4,860 pounds. Prepare Bell’s direct materials budget for January and February.
11. Kendall Company projects 2019 first quarter sales to be $10,000 and increase by 5% per quarter. Determine the projected sales for 2019 by quarter and in total. Round answers to the nearest dollar.
12. Friedman Company manufactures and sells bicycles. A popular model is the XC. The company expects to sell 1,500 XCs in 2018 and 1,800 XCs in 2019. At the beginning of 2018, Friedman has 350 XCs in Finished Goods Inventory and desires to have 10% of the next year’s sales available at the end of the year. How many XCs will Friedman need to produce in 2018?
Using sensitivity analysis in budgeting Riverbed Sporting Goods Store has the following sales budget:
Suppose June sales are expected to be \(81,000 rather than \)65,000. Revise Riverbed’s sales budget.
What do you think about this solution?
We value your feedback to improve our textbook solutions.
Explanations 
Textbooks 
Exams 
GCSE 
IGCSE 
AS 
A Level 
International A Level 
University Admissions Tests 
Flashcards 
Vaia AI 
Notes 
Study Plans 
Study Sets 
Find a job 
Find a degree 
Student Deals 
Magazine 
Mobile App