Ranger wants to have each budget on the MASTER2 worksheet (Below) show not only monthly figures but also totals for the quarter.

-Create column E to present totals for all budget lines (except in the budgeted income statement and balance sheet). Consult your textbook for proper treatment of beginning and ending balances in the production, purchases, and cash budgets.

Sales Hus July 1,600 August 1.400 September 1,500 Unit Dots $313.600 274 400 294 000 Unit Purchases Butiget Desired ending irerlovy Current mortis unit sales Totalsts needed Eleginnergy Purchase(s) July 560 1.600 2,160 640 1.520 Aug 600 1.400 2,000 September 480 1.500 1,900 GOO 10 1.440 Purchases (cars) $167,200 $158.400 $151 800 July $12,400 ALE September $8.000 $3,000 82,320 98,000 62,720 58.800 156,800 54.00 94,000 137200 58300 $230,00 $256,870 $278.400 Cashblut Cashburce, beginning Cashtu Colexionsthm austamers: From May sales From Jure Sales From Julykes From Augustus From September sales Tutil cash Cashbursements Merchandise Variable genes F penses keres Tutal distures Cashbace blure Inding Less Desired ending batance Fress(eticity of cash ornents Financing Bunum Repair Tuld effects of Carchance, ending $136.400 78.400 40,000 D 5254 000 sro 8,000 (5778) $167 200 68.600 40.000 100 5273909 $2,571 8.000 (1429) $158.400 73,500 40,000 191 s2r2001 SAD 8.000 $17989 $7200 D $7200 $8,000 $5.429 D $5,423 $8.000 SU (12.109) (512,700) $13280 $882.000 495.000 $387.000 Forecasted Income Stalet For Quarter Ended September 30 Sales Cost of us suka Gusspruit Expenses Vang Faderes Depreciation experte Wester To despues Net income $220.500 120.000 6.000 300 $346,800 $40200 Forecasted Batuce Sheet as a Seulember 30 Assets Casti Accounts receivable Merchandise inmery Fixed assets (mt) Total assets $13,280 317.520 52,800 124.000 $507600 $151,800 Labetes & equity Accounts partie Les patte Os equity Totalbes & equity 355,800 SOT DO Sales Hus July 1,600 August 1.400 September 1,500 Unit Dots $313.600 274 400 294 000 Unit Purchases Butiget Desired ending irerlovy Current mortis unit sales Totalsts needed Eleginnergy Purchase(s) July 560 1.600 2,160 640 1.520 Aug 600 1.400 2,000 September 480 1.500 1,900 GOO 10 1.440 Purchases (cars) $167,200 $158.400 $151 800 July $12,400 ALE September $8.000 $3,000 82,320 98,000 62,720 58.800 156,800 54.00 94,000 137200 58300 $230,00 $256,870 $278.400 Cashblut Cashburce, beginning Cashtu Colexionsthm austamers: From May sales From Jure Sales From Julykes From Augustus From September sales Tutil cash Cashbursements Merchandise Variable genes F penses keres Tutal distures Cashbace blure Inding Less Desired ending batance Fress(eticity of cash ornents Financing Bunum Repair Tuld effects of Carchance, ending $136.400 78.400 40,000 D 5254 000 sro 8,000 (5778) $167 200 68.600 40.000 100 5273909 $2,571 8.000 (1429) $158.400 73,500 40,000 191 s2r2001 SAD 8.000 $17989 $7200 D $7200 $8,000 $5.429 D $5,423 $8.000 SU (12.109) (512,700) $13280 $882.000 495.000 $387.000 Forecasted Income Stalet For Quarter Ended September 30 Sales Cost of us suka Gusspruit Expenses Vang Faderes Depreciation experte Wester To despues Net income $220.500 120.000 6.000 300 $346,800 $40200 Forecasted Batuce Sheet as a Seulember 30 Assets Casti Accounts receivable Merchandise inmery Fixed assets (mt) Total assets $13,280 317.520 52,800 124.000 $507600 $151,800 Labetes & equity Accounts partie Les patte Os equity Totalbes & equity 355,800 SOT DO