Learning Materials
Features
Discover
Chapter 22: Q13RQ (page 1228)
How is the predetermined overhead allocation rate determined?
It is estimated by dividing the estimated manufacturing costs by the activity base.
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
Preparing a financial budget—cash budget
Booth has \(12,500 in cash on hand on January 1 and has collected the following budget data:
January February
Sales \) 529,000 \( 568,000
Cash receipts from customers 443,000 502,200
Cash payments for direct materials purchases 180,624 160,284
Direct labor costs 135,010 113,348
Manufacturing overhead costs (includes
depreciation of \)900 per month) 55,058 53,922
Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume Booth has cash payments for selling and administrative expenses including salaries of \(40,000 per month plus commissions that are 1% of sales, all paid in the month of sale. The company requires a minimum cash balance of \)20,000. Prepare a cash budget for January and February. Round to the nearest dollar. Will Booth need to borrow cash by the end of February?
Using sensitivity analysis Holly Company prepared the following budgeted income statement for the first quarter of 2018:
Holly Company is considering two options. Option 1 is to increase advertising by \(700 per month. Option 2 is to use better-quality materials in the manufacturing process. The better materials will increase the cost of goods sold to 45% but will provide a better product at the same sales price. The marketing manager projects either option will result in sales increases of 30% per month rather than 20%.
Requirements
1. Prepare budgeted income statements for both options, assuming both options begin in January and January sales remain \)8,000. Round all calculations to the nearest dollar.
2. Which option should Holly choose? Explain your reasoning.
What is the formula used to determine the number of units to be produced?
Describing master budget components
Sarah Edwards, division manager for Pillows Plus, is speaking to the controller, Diana Rothman, about the budgeting process. Sarah states, “I’m not an accountant, so can you explain the three main parts of the master budget to me and tell me their purpose?” Answer Sarah’s question.
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.
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