Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

I NEED HELP WITH ALL OF PART D. Bombs Away video Games Corporation has forecaste

ID: 2820770 • Letter: I

Question

I NEED HELP WITH ALL OF PART D.

Bombs Away video Games Corporation has forecasted the following monthly sales January February March April May June S 50,000 50,000 60,000 90,000 110,000 128,000 105000 July 98,000 August 30,000 September 30,000 October 25,000 November 40,000 December Total annual sales $816,000 Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $5 per unit and costs $2 per unit to produce. A level production policy is followed. Each month's production is equal to annual sales (in units) divided by 12 Of each month's sales, 20 percent are for cash and 80 percent are on account. All accounts receivable are collected in the month after the sale is made

Explanation / Answer

Answer d Cash Budget Bombs Away Video Games Corporation Januray February March April May June July August September October November December Beginning Cash $5,000.00 $28,800.00 $55,200.00 $62,400.00 $15,200.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 Net Cash flow $23,800.00 $26,400.00 $7,200.00 -$47,200.00 -$48,200.00 -$49,200.00 -$35,200.00 -$27,200.00 -$25,200.00 -$11,200.00 $16,800.00 $36,400.00 Cumulative Cash balance $28,800.00 $55,200.00 $62,400.00 $15,200.00 -$33,000.00 -$44,200.00 -$30,200.00 -$22,200.00 -$20,200.00 -$6,200.00 $21,800.00 $41,400.00 Monthly loan or (repayment) $0.00 $0.00 $0.00 $0.00 $38,000.00 $49,200.00 $35,200.00 $27,200.00 $25,200.00 $11,200.00 -$16,800.00 -$36,400.00 Ending Cash balance $28,800.00 $55,200.00 $62,400.00 $15,200.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 Cumulative Loan balance $0.00 $0.00 $0.00 $0.00 $38,000.00 $87,200.00 $122,400.00 $149,600.00 $174,800.00 $186,000.00 $169,200.00 $132,800.00