Bombs Away Video Games Corporation has forecasted the following monthly sales:   January $ 120,000   July $ 65000   February 113000   August 65000   March 45000   September 75000   April 45000   October 105000   May 40000   November 125000   June 55000   December 143000 Total annual sales = $996,000 Bombs Away...

60.1K

Verified Solution

Question

Finance

Bombs Away Video Games Corporation has forecasted the followingmonthly sales:
  January$120,000  July$65000
  February113000  August65000
  March45000  September75000
  April45000  October105000
  May40000  November125000
  June55000  December143000
Total annual sales = $996,000

Bombs Away Video Games sells the popular Strafe and Capturevideo game. It sells for $5 per unit and costs $2 per unit toproduce. A level production policy is followed. Each month'sproduction is equal to annual sales (in units) divided by 12.

   Of each month's sales, 20 percent are for cashand 80 percent are on account. All accounts receivable arecollected in the month after the sale is made.

a.

Construct a monthly production and inventory schedule in units.Beginning inventory in January is 45,000 units.

Bombs Away Video Games Corporation
Production and inventory schedule in units
Beginning
inventory
+ProductionSales=Ending
inventory
  January40,000    
  February  
  March  
  April  
  May  
  June  
  July  
  August  
  September  
  October  
  November  
  December  
b.

Prepare a monthly schedule of cash receipts. Sales in Decemberbefore the planning year are $100,000.

Bombs Away Video Games Corporation
Cash Receipts Schedule
JanuaryFebruaryMarchAprilMayJune
  Sales$$$$$$   
  Cash receipts:
  Cash sales$$$$$$   
  Prior month's credit sales  
  Total cash receipts$$$$$$   
Bombs Away Video Games Corporation
Cash Receipts Schedule
JulyAugustSeptemberOctoberNovemberDecember
  Sales$$$$$$   
  Cash receipts:
  Cash sales$$$$$$   
  Prior month's credit sales  
  Total cash receipts$$$$$$   

Answer & Explanation Solved by verified expert
3.9 Ratings (407 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Bombs Away Video Games Corporation has forecasted the followingmonthly sales:  January$120,000  July$65000  February113000  August65000  March45000  September75000  April45000  October105000  May40000  November125000  June55000  December143000Total annual sales = $996,000Bombs Away Video Games sells the popular Strafe and Capturevideo game. It sells for $5 per unit and costs $2 per unit toproduce. A level production policy is followed. Each month'sproduction is equal to annual sales (in units) divided by 12.   Of each month's sales, 20 percent are for cashand 80 percent are on account. All accounts receivable arecollected in the month after the sale is made.a.Construct a monthly production and inventory schedule in units.Beginning inventory in January is 45,000 units.Bombs Away Video Games CorporationProduction and inventory schedule in unitsBeginninginventory+Production–Sales=Endinginventory  January40,000      February    March    April    May    June    July    August    September    October    November    December  b.Prepare a monthly schedule of cash receipts. Sales in Decemberbefore the planning year are $100,000.Bombs Away Video Games CorporationCash Receipts ScheduleJanuaryFebruaryMarchAprilMayJune  Sales$$$$$$     Cash receipts:  Cash sales$$$$$$     Prior month's credit sales    Total cash receipts$$$$$$   Bombs Away Video Games CorporationCash Receipts ScheduleJulyAugustSeptemberOctoberNovemberDecember  Sales$$$$$$     Cash receipts:  Cash sales$$$$$$     Prior month's credit sales    Total cash receipts$$$$$$   

Other questions asked by students