Question: please just check my work and help/explain in Preparing the Budgeted Income Statement based on the information given. The selling price per unit is $50.00.

please just check my work and help/explain in Preparing the Budgeted Income Statement based on the information given.

  1. The selling price per unit is $50.00.
December January February March Total
Budgeted unit Sales 50,000 70,000 100,000 60,000 230,000
Add desired ending merchandise inventory 31,500 45,000 27,000 45,000 117,000
Total needs 81,500 115,000 127,000 105,000 347,000
Less beginning merchandise inventory 22,500 31,500 45,000 27,000 103,500
Required purchases 59,000 83,500 82,000 78,000 243,500
Unit product cost $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00
Cost of inventory purchases $ 2,065,000 $ 2,922,500 $ 2,870,000 $ 2,730,000 $ 8,522,500
January February March Total
Budgeted units sales 70,000 100,000 60,000 230,000
Variable selling and administrative expense per unit $ 12.00 $ 12.00 $ 12.00 $ 12.00
Total variable selling and administrative expense $ 840,000 $ 1,200,000 $ 720,000 $ 2,760,000
Fixed selling and administrative expenses
Advertising $ 24,000 $ 24,000 $ 24,000 $ 72,000
Rent $ 35,000 $ 35,000 $ 35,000 $ 105,000
Depreciation $ 66,000 $ 66,000 $ 66,000 $ 198,000
Total fixed selling and administrative expenses $ 125,000 $ 125,000 $ 125,000 $ 375,000
Total selling and administrative expenses $ 965,000 $ 1,325,000 $ 845,000 $ 3,135,000
Less depreciation $ 66,000 $ 66,000 $ 66,000 $ 198,000
Cash disbursements for selling and administrative expenses $ 899,000 $ 1,259,000 $ 779,000

$ 2,937,000

January February March Total
Beginning cash balance $ 70,000 $ 70,000 $ 70,000 $ 210,000
add cash receipts
Cash collections from customers $ 2,950,000 $ 4,175,000 $ 4,100,000 $ 11,225,000
Total cash available $ 3,020,000 $ 4,245,000 $ 4,170,000 $ 11,435,000
Less cash disbursements
Total cash disbursements for merchandise purchases 2,065,000.00 $ 2,922,500 $ 2,870,000 $ 7,857,500
Cash from Selling and administrative $ 840,000 $ 1,200,000 $ 720,000 $ 2,760,000
Dividend $ 20,000 $ 20,000.00
other expenses $ 59,000.00 $ 59,000.00 $ 59,000.00 $ 177,000.00
Total cash disbursements $ 2,964,000 $ 4,201,500 $ 3,649,000 $ 10,814,500
Excess (deficiency) of cash available over disbursements $ 56,000 $ 43,500 $ 521,000 $ 620,500
Financing
Borrowing (at the beginnings of the month) $ 14,000 $ 26,500 $ 40,500
Repayments (at end of the month) $ (40,500) $ (40,500)
Interest $ (545) $ (545)
Total financing $ 14,000 $ 26,500 $ (41,045) $ (545)
Ending cash balance $ 70,000 $ 70,000 $ 479,955 $ 619,955
Sales
Cost of goods sold
Gross margin
Selling and administrative expenses
Net operating Income
Interest expense
Net Income

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!