Please answer all questions
You are responsible for preparing the following budgets or schedules:A. Sales forecastB. Manufacturing cost budgetC. Cash budgetD. Production scheduleE. Operating expense budgetF. Budgeted balance sheet
Projected Sales Forecast:Time Periods 1 2 3 4Sales in units 12,000 13,000 15,000 10,000
Production Schedule for 2001Quarter: 1st 2nd 3rd 4thExpected sales units 7,000 5,000 8,000 6,000Units produced 6,800 --to be determined--
Sales Forecast:Month October November December JanuaryCredit Sales $40,000 $50,000 $60,000 $35,000
Direct Materials Budget:Budget quarters 1st 2nd 3rd 4thCredit purchases of materials $54,000 $60,000 $70,000 $56,000
Production schedule:Quarter 1st 2nd 3rd 4thProduction units 20,000 30,000 50,000 10,000^
Production Schedule:Quarter 1st 2nd 3rdBeginning inventory 5,000 4,000 12,000Budgeted unit sales 50,000 40,000 120,000Desired ending finished goods 4,000 12,000 15,000
Data taken from the sales forecast, the manufacturing cost budget, and the schedules of cash payment:Quarter First SecondPlanned production units: 7,000 7,500Budgeted variable overhead costs: $15,000 $18,750Budgeted fixed manufacturing overhead: unknown unknownBudgeted depreciation included in total overhead: $ 3,000 $ 3,000 Budgeted cash payments for total overhead: $20,000 $23,750
Quarters First Second Third FourthBudgeted direct-labor hours 60,000 80,000 75,000 70,000Variable overhead rate/hour $3.00 $3.00 $3.00 $3.00Fixed manufacturing overhead $80,000 $80,000 $80,000 $80,000The fixed manufacturing overhead includes depreciation of $35,000 per quarter.
The following events and balances have been projected:(1) Cash sales totaling $380,000(2) A $30,000 beginning cash balance(3) Expenses of $420,000, which include $20,000 of depreciation and $12,000 of interest(4) End-of-period accrued liabilities of $20,000 for unpaid expenses(5) Borrowing $50,000 cash by issuing a note payable
Amounts budgeted for 10,000 units of planned production:Direct materials $ 80,000Direct labor 120,000Variable manufacturing overhead costs 100,000Fixed manufacturing overhead costs 50,000