Solution b:
Bombs Away Video games Corporation | ||||||||||||
Cash Receipts Schedule | ||||||||||||
January | February | March | April | May | June | July | August | September | October | November | December | |
Sales | $99,000 | $92,000 | $24,000 | $24,000 | $19,000 | $34,000 | $44,000 | $44,000 | $54,000 | $84,000 | $1,04,000 | $1,22,000 |
Cash Receipts: | ||||||||||||
Cash Sales (20% of sales) | $19,800 | $18,400 | $4,800 | $4,800 | $3,800 | $6,800 | $8,800 | $8,800 | $10,800 | $16,800 | $20,800 | $24,400 |
Prior Month's credit sales (80% of prior month sales) | $80,000 | $79,200 | $73,600 | $19,200 | $19,200 | $15,200 | $27,200 | $35,200 | $35,200 | $43,200 | $67,200 | $83,200 |
Total Cash Receipts | $99,800 | $97,600 | $78,400 | $24,000 | $23,000 | $22,000 | $36,000 | $44,000 | $46,000 | $60,000 | $88,000 | $1,07,600 |
Bombs Away Video games Corporation | ||||||||||||
Cash Payments Schedule | ||||||||||||
January | February | March | April | May | June | July | August | September | October | November | December | |
Production costs (12400*$2) | $24,800 | $24,800 | $24,800 | $24,800 | $24,800 | $24,800 | $24,800 | $24,800 | $24,800 | $24,800 | $24,800 | $24,800 |
Other Cash Payments | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 |
Total Cash Payments | $68,800 | $68,800 | $68,800 | $68,800 | $68,800 | $68,800 | $68,800 | $68,800 | $68,800 | $68,800 | $68,800 | $68,800 |
Bombs Away Video games Corporation | ||||||||||||
Cash Budget | ||||||||||||
January | February | March | April | May | June | July | August | September | October | November | December | |
Beginning Cash | $5,000 | $36,000 | $64,800 | $74,400 | $29,600 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Net Cash Flow | $31,000 | $28,800 | $9,600 | -$44,800 | -$45,800 | -$46,800 | -$32,800 | -$24,800 | -$22,800 | -$8,800 | $19,200 | $38,800 |
Cumulative Cash Balance | $36,000 | $64,800 | $74,400 | $29,600 | -$16,200 | -$41,800 | -$27,800 | -$19,800 | -$17,800 | -$3,800 | $24,200 | $43,800 |
Monthly loan or (repayment) | $0 | $0 | $0 | $0 | $21,200 | $46,800 | $32,800 | $24,800 | $22,800 | $8,800 | -$19,200 | -$38,800 |
Ending Cash Balance | $36,000 | $64,800 | $74,400 | $29,600 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Cumulative loan balance | $0 | $0 | $0 | $0 | $21,200 | $68,000 | $1,00,800 | $1,25,600 | $1,48,400 | $1,57,200 | $1,38,000 | $99,200 |
Bombs Away Video Games Corporation has forecasted the following monthly sales S 99,000 July $ 44,000...
Bombs Away Video Games Corporation has forecasted the following monthly sales: S 44,000 44,000 54,000 84,000 104,000 122,000 January S 99,000 July March Apn May June 92,000 August 24,000 September 24,000 October 19.000 November 34,000 December Total annual sales $744,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 110,000 July $ 55,000 February 103,000 August 55,000 March 35,000 September 65,000 April 35,000 October 95,000 May 30,000 November 115,000 June 45,000 December 133,000 Total annual sales = $876,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 106,000 July $ 51,000 February 99,000 August 51,000 March 31,000 September 61,000 April 31,000 October 91,000 May 26,000 November 111,000 June 41,000 December 129,000 Total annual sales = $828,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $103,000 July $ 48,000 February 96,000 August 48,000 March 28,000 September 58,000 April 28,000 October 88,000 May 23,000 November 108,000 June 38,000 December 126,000 Total annual sales = $792,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales January $107,000 July February100,000 August March $ 52,000 52,000 32,000 September 62,000 92,000 27,000 November 112,000 42,000 December 130,000 ril May June 32,000 October Total annual sales $840,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)...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January February March April May June $ 101,000 $101,0 July $ 46,000 94,000 August 46,000 26,000 September 56,000 26,000 October 86,000 21,000 November 106,000 36,000 December 124,000 Total annual sales = $768,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 104,000 July $ 49,000 February 97,000 August 49,000 March 29,000 September 59,000 April 29,000 October 89,000 May 24,000 November 109,000 June 39,000 December 127,000 Total annual sales = $804,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 101,000 July $ 46,000 February 94,000 August 46,000 March 26,000 September 56,000 April 26,000 October 86,000 May 21,000 November 106,000 June 36,000 December 124,000 Total annual sales = $768,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...
Help with all of the red X’s please!! They are not 0!!!! I’ve already tried that. Bombs Away Video Games Corporation has forecasted the following monthly sales: anuary $ 96,000 July 89,000 August 21,000 September 1,000 October 16,000 November 31,000 December S 41,000 41,000 51,000 81,000 101,000 119,000 Total annual sales $708,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...
Esquire Products Inc. expects the following monthly sales: January February March April May June $ 38,000 July 29,000 August 22,000 September 24,000 October 18.ee November 16,eee December Total sales = $384,cee $ 32,000 36,000 39,000 44,000 52,00 34, eee Cash sales are 40 percent in a given month, with the remainder going into accounts receivable. All receivables are collected in the month following the sale. Esquire sells all of its goods for $2 each and produces them for $1 each....