Bombs Away Video Games Corporation has forecasted the following monthly sales: January February March April May...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bombs Away Video Games Corporation has forecasted the following monthly sales: January February March April May June $ 119,000 112,000 44,000 44,000 July August $ 64,000 64,000 74,000 FUKU 39,000 September October November 54,000 December 184,000 124,000 142,000 Total annual sales = $984,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, 40 percent are for cash and 60 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 44,000 units Note: Input all your answers as positive numbers. 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. Note: Negative amounts should be indicated by a minus sign. Leave no cells blank be certain to enter '0' wherever required. Bombs Away Video Games Corporation Cash Budget January February March April May June Beginning cash 5,000 $ 15,800 $ 35,200 $ 23,200 $ 5.000 $ 5,000 Net cash flow Cumulative cash balance S 15,800 $ 35,200 $ Monthly loan or (repayment) S Ending cash balance 15.300 S 35 2007 $ Cumulative oan balance S 23.200 $ OF $ 23 200 $ 07 5 (29.600) 34,800 5.000 S 34,800 $ S (49.800) $ 54,800 5.000 $ 89.400 S (46,800) 51,800 5,000 141,200 Bombs Away Video Games Corporation Cash Budget July August September October Beginning cash 5.000 S 5.000 S 5,000 $ 5.000 S file: cash flow Cumulative cash balance Monthly loan ct (repayment) 3 133.800 S 38 800 Erding cash balance S Dumulative loan balance S 5000 S 180,000 S (27.800) S 32.800 5.000 S 212.800 S (23.800) S 28.800 5.000 S 241,800 $ (5,800 $ 10.800 5.000 $ 252 400 S November December 5.000 S 5,000 20 200 S (15-200) 5.000 S 237 200 S 39,400 (34,400) 5.000 202.800 Bombs Away Video Games Corporation has forecasted the following monthly sales: January February March April May June $ 119,000 112,000 44,000 44,000 July August $ 64,000 64,000 74,000 FUKU 39,000 September October November 54,000 December 184,000 124,000 142,000 Total annual sales = $984,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, 40 percent are for cash and 60 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 44,000 units Note: Input all your answers as positive numbers. 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. Note: Negative amounts should be indicated by a minus sign. Leave no cells blank be certain to enter '0' wherever required. Bombs Away Video Games Corporation Cash Budget January February March April May June Beginning cash 5,000 $ 15,800 $ 35,200 $ 23,200 $ 5.000 $ 5,000 Net cash flow Cumulative cash balance S 15,800 $ 35,200 $ Monthly loan or (repayment) S Ending cash balance 15.300 S 35 2007 $ Cumulative oan balance S 23.200 $ OF $ 23 200 $ 07 5 (29.600) 34,800 5.000 S 34,800 $ S (49.800) $ 54,800 5.000 $ 89.400 S (46,800) 51,800 5,000 141,200 Bombs Away Video Games Corporation Cash Budget July August September October Beginning cash 5.000 S 5.000 S 5,000 $ 5.000 S file: cash flow Cumulative cash balance Monthly loan ct (repayment) 3 133.800 S 38 800 Erding cash balance S Dumulative loan balance S 5000 S 180,000 S (27.800) S 32.800 5.000 S 212.800 S (23.800) S 28.800 5.000 S 241,800 $ (5,800 $ 10.800 5.000 $ 252 400 S November December 5.000 S 5,000 20 200 S (15-200) 5.000 S 237 200 S 39,400 (34,400) 5.000 202.800
Expert Answer:
Answer rating: 100% (QA)
Bombs Away Video Games Corporation Cash Budget March April Beginning Cash Balance 6000 Given Month C... View the full answer
Related Book For
Foundations of Financial Management
ISBN: 978-1259194078
15th edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen
Posted Date:
Students also viewed these accounting questions
-
Markus Company's common stock sold for $4.50 per share at the end of this year. The company paid a common stock dividend of $0.63 per share this year. It also provided the following data excerpts...
-
Nicole Mariotte is unmarried, filing single. In the second week of February, she earned $707.35. Deductions from her pay included federal withholding, Social Security, Medicare, health insurance for...
-
in title insuarance, the insurer won;t cover a loss that falls within a / an 1 . elimination 2 . excusion 3 . deduction 4 . refrection
-
1) Write a generic function to integrate y(x)dx with the following format function I integrator (x, y, method) where x is a vector and y is a matrix whose columns y(:,j) are vectors of the same...
-
Indicate whether each of the following items should be classified as an operating, investing, or financing activity on the statement of cash flows. If an item does not belong on the statement,...
-
Ace Manufacturing, Inc. purchased a new piece of manufacturing equipment at a total acquisition cost of $ 3,000,000 on January 4 of the current year. The firm estimates that the equipment has a...
-
Mountain Petroleum had an exploratory well in progress at the end of 2018. Total costs incurred by 12/31/18 were $300,000. During January 2019, drilling was continued, and costs of $200,000 were...
-
John Roberts is 55 years old and has been asked to accept early retirement from his company. The company has offered John three alternative compensation packages to induce John to retire: 1. $180,000...
-
A particle is moving along the curve y = 34x+1. As the particle passes through the point (2,9), its 2-coordinate increases at a rate of 3 units per second. Find the rate of change of the distance...
-
The data displayed in the plot below are from a nearly complete record of body masses of the worlds native mammals (in grams, then converted to log-base 10; Smith et al. 2003). The data were divided...
-
Explain the concept of elasticity of demand and supply and how it affects pricing decisions of firms. Discuss the factors that influence the elasticity of demand and supply for a product or service.
-
Calculating GDP, Net Exports, and NNP Based on the information in Table : What is the value of GDP? What is the value of net exports? What is the value of NNP? Government purchases $120 billion...
-
Giants Inc. manufactures specialized precision electronic kits. In late March, Job Orders #0311 and #0322 were started. Estimated material costs were P90,000 for both orders (60% for #0311) while...
-
What is the cause root ofthe law of diminishing marginal product
-
Dr. Froeb absolutely agrees with Jon. "Problem-solving proceeds in two steps. First, reduce a problem to a bad decision, and then figure out who made it and why. Second, figure out how to ensure that...
-
a) If your savings account earns 6% per annum, compounded annually, how much do you have in your account at the end of 10 years if you deposit $10,000 per year into the account? b) How much will you...
-
A bond that has $1,000 par value and a coupon interest rate of 9 percent. A new issue would have a flotation cost of 5 percent of the $1,100 market value. The bond mature in 10 years. The firm's...
-
State whether each of the following will increase or decrease the power of a one-way between-subjects ANOVA. (a) The effect size increases. (b) Mean square error decreases. (c) Mean square between...
-
Dhariwal Industries is currently reviewing its variance analysis process. Over the years, the company has used variance analysis to help control and manage costs and activities within the company....
-
Elsies Muffins makes two types of muffin that are sold to grocery stores: the standard muffin (which comes in various flavours such as carrot, chocolate chip, bran, and apple spice) and the gourmet...
-
Which of the following would indicate a high level of supplier power in an industry* a. Many suppliers in the industry provide similar products. b. A companys sales represent a high portion of the...
Study smarter with the SolutionInn App