Chapter 22: 20RQ (page 1228)
What is sensitivity analysis? Why is it important for managers?
Sensitivity analysis is a what-if technique.
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
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.
Preparing a financial budget—schedule of cash payments
Marcel Company has the following projected costs for manufacturing and selling and administrative expenses:
January February March Direct materials purchases \( 3,100 \) 3,500 $ 4,800 Direct labor costs 3,300 3,500 3,600 Depreciation on plant 550 550 550 Utilities for plant 650 650 650 Property taxes on plant 200 200 200 Depreciation on office 550 550 550 Utilities for office 250 250 250 Property taxes on office 170 170 170 Office salaries 3,500 3,500 3,500
All costs are paid in month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a zero balance on January 1. Prepare a schedule of cash payments for Marcel for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31.
Why is the sales budget considered the cornerstone of the master budget?
Preparing an operating budget—inventory, purchases, and cost of goods sold budget
Slate, Inc. sells tire rims. Its sales budget for the nine months ended September 30, 2018, follows:
Quarter Ended Nine-MonthTotal
March 31 June 30 September 30 Cash sales, 20% \( 28,000 \) 38,000 \( 33,000 \) 99,000
Credit sales, 80% 112,000 152,000 132,000 396,000 Total sales \( 140,000 \) 190,000 \( 165,000 \) 495,000
In the past, cost of goods sold has been 40% of total sales. The director of marketing and the financial vice president agree that each quarter’s ending inventory should not be below \(5,000 plus 10% of cost of goods sold for the following quarter. The marketing director expects sales of \)240,000 during the fourth quarter. The January 1 inventory was $38,000. Prepare an inventory, purchases, and cost of goods sold budget for each of the first three quarters of the year. Compute cost of goods sold for the entire nine-month period.
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.
