Question: create these budgets selling and administrative expense budget cash budget...
Create These budgets:
-selling and administrative expense budget
-cash budget include a schedule of cash collections and payments
-finished goods inventory calculation
Then, Create the following schedules, financial statements, and calculations
A) Pro forma cost of goods manufactured
B) Pro forma Cost of goods sold- both financial and variable cost basis
C) Pro forma income statement (financial basis)
D) Pro forma balance sheet
E)Pro forma Income statement (variable cost basis)
F) Pro forma statement of retained earnings
G) breakeven analysis: 1. breakeven sales level in units and dollars. 2. cost volume profit graph showing the breakeven point
H) Flexible Budget 1. Create the flexible budget results for production costs as if actual production were 160,000 units in the first quarter of 2019 2. Add flexible budget results for slightly higher and slightly lower production at 170,000 units and 150,000 units, respectively.
Here are the numbers:
Here are the templates: