Question: You will prepare a one year master budget with the data contained in SUPERBUD. This master budget WILL contain the following budgets Sales Sales Collections
You will prepare a one year master budget with the data contained in SUPERBUD. This master budget WILL contain the following budgets Sales Sales Collections Production Direct Materials (including purchasing schedule) Direct Labor Manufacturing Overhead Selling and Admin Expenses Cash Budget Income Statement (one for every month) Balance Sheet (one for every month) The data sheet and all the budgets must be interlinked so that when I change the price or any other data point in the data sheet I will see the appropriate change in the last month of the balance sheet. Linking everything together is worth 25% of the points
Superbud Check figures
| January Sales GNU | $68,000 |
| January Sales TSE | $36,000 |
| January cash receipts | $111,860 |
| January production GNU | 1,940 units |
| January production TSE | 3,300 units |
| January Total HYUN purchase | 9,120 units |
| January Total Esta purchase | 13,000 units |
| January Purchase HYUN | 9,060 units |
| January Cost HYUN | $13,590 |
| January Purchase Esta | 12,700 units |
| January Cost Esta | $26,670 |
| January cash disbursement raw materials | $45,678 |
| January cash disbursement direct labor | $21,540 |
| January cash disbursement overhead | $13,760 |
| January cash disbursement selling & admin | $16,400 |
| January Ending Cash | $28,232 |
| February Ending Cash | $38,096 |
| December Ending Cash | $315,769 |
| January Net Income | $11,800 |
| February Net Income | $12,880 |
| December Net Income | $21,900 |
| Total Net Income for the Year | $327,000 |
| January Total Assets | $371,000 |
| February Total Assets | $384,324 |
| December Total Assets | $689,637 |


That's the all materials I get from my teacher.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
