Question

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 months production is equal to annual sales (in unlits) divided by 12. Of each months 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. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 24,000 units. Bombs Away Video Games Corporation Production and Inventory Schedule in Units BeginningProductionSales Ending 21,000 16,600 10,600 18,200 25,800 34 400 0,000 43,600 47,200 48.800 44,400 36.000 12,100 12.400 12,400 12.400 12,400 12,400 12,400 12,400 12.400 12.400 12.400 12.400 19,800 18,400 1,800 4,800 3,800 6,800 8,800 B,800 10,800 16,800 20,800 24,400 16,600 10,600 18,200 5,800 34,400 40,000 13,600 47,200 48,800 44 400 36,000 24,000 February March April May July August October

b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000 Bombs Away Video Games Corporation Cash Receipts Schedule January February March April May June Sales Cash receipts Cash sale:s Prior months credit sales Total cash receipts 0 S Bombs Away Video Games Corporation Cash Receipts Schedule July August September October November December Sales Cash receipts Cash sales Prior months credit sales Total cash receipts

c. Prepare a cash payments schedule for January through December. The production costs of $2 per unit are paid for in the month in which they occur. Other cash payments, besides those for production costs, are $44,000 per month Bombs Away Video Games Corporation Cash Payments Schedule January February March April May June Production cost Otner cash payments Total cash paymcnts Bombs Away Video Games Corporation Cash Payments Schedule August July October November December Production cost Other cash payments Total cash payments

d. Prepare a monthly cash budget for January through December using the cash receipts schedule from part b and the cash payments schedule from part c. The beginning cash balance is $5,000, which is also the minimum desired. (Negative amounts should be indicated by a minus sign.) Bombs Away Video Games C Cash Budget January February March April May June Beginning cash Nct cash tow Cumulative cash balance Montnly loan or (repayment) Ending cash balance Cumulative loan balarice Bombs Away Video Games Corporation Cash Budget July August September October November December Beginning cash Net cash ow Cumulative cash balance Monthly loan or (repayment) Ending cash balanoc Cumulative loan balance

0 0
Add a comment Improve this question Transcribed image text
Answer #1

b. Cash Receipts Schedule:

2 4 Bomb Awav Video Games Corporatioin Cash Receipts Schedule January (S) February (S) March (S)April (S)May(S) June(S) Sales Cash Redc Cash Sales (20% on Sales) (a) Prior months credit sales Total cash receipts (a +b) 99.000 92,000 24,000 24,000 19,000 34,000 19,800 80,000 99,800 18,400 79,200 97,600 4,800 73,600 78,400 4,800 19,200 24,000 3.800 19,200 23,000 6,800 15.200 22,000 10 12 13 14 15 16 17 Bomb Awav Video Games Corporatioin Cash Receipts Schedule July (S)August (S) September (S) October (S) November (S) December (S) 122,000 Sales Cash Receipts: Cash Sales (20% on Sales) (a) 44.000 44.000 54,000 84.000 104,000 8,800 27,200 36,000 8,800 35,200 44,000 10,800 35,200 46,000 16,800 43.200 60,000 20,800 67,200 88,000 24,400 83.200 107,600 19 20 Prior months credit sales Total cash receipts (a +b)

Excel formulas:

Bomb Away Video Games Corporation Cash Receipts Schedule January (S) February (S) March (S)April (S)May S 24000 June(S) 34000 Sales Cash Rec Cash Sales (20% on Sales) (a) Prior months credit sales Total cash receipts (a b 92000 24000 19000 -08*0.2 N8*0.8 -18*0.2 K8*0.2 100000*0.8-J8*0.8 L8*0.2 K8*0.8 M8*0.2 L8*0.8 M10+Mil EN10+N11 010+011 N8*0.2 M8 0.8 10 Kl0+Kii L10+L11 12 13 14 15 16 17 18 19 20 21 Bomb Awav Video Games Corporation July (S) 44000 Cash Receipts Schedule August (S) September (S) October (S) November (S) December (S) 44000 Sales Cash Rec Cash Sales (20% on Sales) (a) Prior months credit sales Total cash receipts (a + b) 54000 84000 104000 122000 L17*0.2 K17*0.8 -L19+L20 M17 0.2 =L 17*0.8 -MI9tM20 N17*0.2 -M17*0.8 -N19tN20-019+O20 -J 17*0.2 08*0.8 -J19+J20 K17*0.2 -J17*0.8 -Kl9tK20 017*0.2 N17*0.8

c) Cash Payments Schedule:

Bomb Awav Video Games Corporatioin Cash Pavments Schedule 24 25 26 27 28 29 30 31 32 January (S) February (S) March (S) April

Excel formulas:

Bomb Awav Video Games Corporation Cash Pavments Schedule 23 24 25 26 27 28 29 May(S) June(S) January (S) -12400*2 44000 |:J2G+J27 February (S) March (S) 12400 2 12400 2 44000 -K26+K27 April (S) -12400*2 44000 -M26+3127 Production Cost (a Other Cash Payments Total Cash Payments (a + b) 12400 2 44000 12400 2 44000 -O26+027 44000 -L2G+し27 |=N2G+N27 31 32 Bomb Awav Video Games Corporation Cash Pavments Schedule August (S) September (S) October (S) November (S) December (S) July (S) 34 35 36 37 12400 2 44000 *2 12400 2 124002 44000 12400 2 Production Cost (a Other Cash P Total Cash Payments (a+b) J35+J36 K35+K36 FL35+L36 -12400*2 44000 44000 44000 44000 M35+M36 EN35+N36 035+036

d) Cash Budget:

41 42 43 Bomb Awav Video Games Corporatioin Cash Budget January (S) February (S) March (S)April (S)May(S) June(S) Cash (a) 5,000 36,000 64,800 74,400 29,600 5,000 Net Cash Flow (Total Cash Receipts - Total Cash payments)31,000 28,800 9,600 -44,800 -45,800 -46,800 45 Cumulative cash balance (a+b Monthly loan or repayment Ending cash balance Cumulative loan balance -16,200 21,200 5.000 21,200 36,000 64,800 74,400 29,600 -41,800 -46,800 5.000 68,000 47 36,000 64,800 74,400 29,600 49 Bomb Awav Video Games Corporatioin Cash Budget 51 52 53 July (S)August (S) September (S) October (S) November (S) December (S) 5.000 Cash (a) 5.000 5.000 5.000 5.000 5.000 Net Cash Flow (Total Cash Receipts - Total Cash payments) -32,800 -27,800 -32,800 5,000 100,800 24,800 19,800 24,800 5,000 125,600 8,800 -3,800 8,800 5,000 148,400157,200 22,800 17,800 22,800 5,000 19.200 24,200 19,200 5,000 138,000 38,800 43.800 38,800 5,000 99,200 54 56 57 58 Cumulative cash balance (a+b Monthly loan orr Ending cash balance Cumulative loan balance

Excel formulas:

Add a comment
Know the answer?
Add Answer to:
Bombs Away Video Games Corporation has forecasted the following monthly sales: S 44,000 44,000 54,000 84,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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 99,000 July $ 44,000 44,000 54,000 84,000 104,000 122,000 January February March ril May June 92,000 August 24,000September 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 $...

    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...

    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...

    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...

    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...

    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 $...

    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...

    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...

  • Business Finance

    Front Page Video Games Corporation has forecasted the following monthly sales:    January$99,000    July$44,000    February92,000    August44,000    March24,000    September54,000    April24,000    October84,000    May19,000    November104,000    June34,000    December122,000    Total sales = $744,000 The firm sells its Last Spike video game for $5 per unit, and the cost to produce the game is $2 per unit. 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...

  • Help with all of the red X’s please!! They are not 0!!!! I’ve already tried that....

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT