Question
Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget
Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget:
Rumble | Thunder | ||
Estimated inventory (units), June 1 | 278 | 69 | |
Desired inventory (units), June 30 | 319 | 60 | |
Expected sales volume (units): | |||
Midwest Region | 3,300 | 2,900 | |
South Region | 5,800 | 5,050 | |
Unit sales price | $110 | $195 |
Question Content Area
a. Prepare a sales budget.
Product and Area | Unit Sales Volume | Unit Selling Price | Total Sales |
Model: Rumble | |||
Midwest Region | 3300 | $110 | $fill in the blank |
South Region | 5800 | 110 | fill in the blank |
Total | 9100 | $fill in the blank | |
Model: Thunder | |||
Midwest Region | 2900 | $195 | $fill in the blank |
South Region | 5050 | 195 | fill in the blank |
Total | 7950 | $fill in the blank | |
Total revenue from sales | $fill in the blank |
b. Prepare a production budget. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Units Rumble | Units Thunder | |
Expected units to be sold | fill in the blank | fill in the blank |
Desired inventory, June 30 | fill in the blank | fill in the blank |
Total | fill in the blank | fill in the blank |
Estimated inventory, June 1 | fill in the blank | fill in the blank |
Total units to be produced | fill in the blank | Fill in the blank |
EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (JanuaryMarch). The Accrued Expenses Payable balance on January 1 is $29,800. The budgeted expenses for the next three months are as follows:
January | February | March | ||||
Salaries | $68,500 | $83,400 | $92,400 | |||
Utilities | 5,700 | 6,300 | 7,500 | |||
Other operating expenses | 52,700 | 57,400 | 63,200 | |||
Total | $126,900 | $147,100 | $163,100 |
Other operating expenses include $3,800 of monthly depreciation expense and $900 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 65% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December.
Prepare a schedule of cash payments for operations for January, February, and March. Enter all amounts as positive numbers.
January | February | March | |
Payments of prior month's expense | $29800 | $ fill in the blank | $fill in the blank |
Payments of current month's expense | fill in the blank | fill in the blank | fill in the blank |
Total cash payments | $fill in the blank 9 | $fill in the blank 10 | $fill in the blank 11 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started