Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

there is four parts to this questiin A,B,C(on side), and D. first picture is the problem,Second picture is the description for A,B,C,and D Two Year

there is four parts to this questiin A,B,C(on side), and D.
first picture is the problem,Second picture is the description for A,B,C,and D image text in transcribed
image text in transcribed
Two Year Variable Short-term Financing 13 fer to Problem 6-21 (Page 113 Primis. 189) Level Production and related financing effects There are four separate sections (questions to this problem A.B.C. & D Total dollar sales for the year amount to $756,000 "All sales priced at $5.00 Question Bombs Away Video Games Corporation A Production and Inventory Schedule: Begin Units of Units of Ending Month Inventory Production Sales Inventory Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Question B Month Jan Feb Mar AR May Jun JUI Aug Sep Oct Nov Dec Bombs Away Video Games Corporation Cash Receipts Schedule Sales cash from cash from Total Cash in dollars) this month prior month Receipts $100,000 70.000 $93.000 $25,000 $25,000 $20.000 $35,000 $45.000 $45.000 $55 000 $85.000 $105 000 $123 000 December sales of $100,000 Question Sharpe Computer Graphics Corporation Cash Payments Schedule Note: With level production and other cash payments fixed, you need only calculate for a single month as all months are the same. Show your answers in the yellow cells below. Cost to produce Calc. Net Other cash pay Cash Flow Total Cash Pat Enter negative amount as minus Use column "K" to calculate Net Cash Flow for Problem D below (only column "D" below will be graded You can Copy and paste to "D" below, if you wish Question D Bombs Away Video Games Corporation Cash Budget "receipts less payments (8.c Ner" Beginning Cumulative Loan (0) cumulative Ending Month cash flow Cash Budged cash balance Regovo loan cash balance Jan 5,000 Feb Mar Apl May Jun JU Aug Sep Oct Nov Dec NOIL net cash llows - cash receipts (3) less cash payments () - show negative as a minus cumulative cash balance - net receipts plus beginning cash (enter negative as a minus monthly loan or repayment - show new loan as positive and repay as negative $ 65,000 55,000 100,000 45,000 (L d. Prepare a monthly cash budget for January through December using the January February March April Sales in December of the prior year were $75,000. Prepare a cash receipts schedule for January through April. 21. Bombs Away Video Games Corporation has forecasted the following monthly sales: January $100,000 July $ 45,000 February 93,000 August 45,000 March 25,000 September 55,000 April 25,000 October 85,000 May 20,000 November 105,000 June 35,000 December 123,000 Total annual sales = $756,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, 30 percent are for cash and 70 percent are on account. All accounts receivable are collected in the month after the sale is made. 4. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 25,000 units. (Note: To do part a, you should work in terms of units of production and units of sales.) b. Prepare a monthly schedule of cash receipts. Sales in the December before the planning year are $100,000. Work part b using dollars. Determine a cash payments schedule for January through December. The pro cash payments, besides those for production costs, are $45,000 per month. duction costs of $2 per unit are paid for in the month in which they occur. Other cash receipts schedule from part band the cash payments schedule from part e, The beginning cash balance is $5,000, which is also the minimum n. Esquire Products Inc. expects the following monthly sales: June September desired. January February March $28,000 19,000 May $ 8,000 $29.000 And

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sarbanes Oxley And The New Internal Auditing Rules

Authors: Robert R. Moeller

1st Edition

0471483060, 978-0471483069

More Books

Students also viewed these Accounting questions