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

You will prepare a one year master budget with the data containedin SUPERBUD. This master budget WILL contain the following budgets Sales Sales

That's the all materials I get from my teacher.Collections Production Direct Materials (including purchasing schedule) Direct Labor Manufacturing Overhead Selling

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!