Find the unknowns in big chucks abbreviated cash budget

Assignment Help Financial Accounting
Reference no: EM13488659

Production and cash-outlay computations

RPR, Inc., anticipates that 120,000 units of product K will be sold during May. Each unit of product K requires four units of raw material A. Actual inventories as of May 1 and budgeted inventories as of May 31 follow.


1-May

31-May

Product K (Units)

         55,000

       60,000

Rate Materials A (Units)

         40,000

       37,000

 

Each unit of raw material A costs $8; RPR pays for all purchases in the month of acquisition. Invoices that account for 80% of the cost of materials acquired will be paid within 10 days of receipt, entitling the company to a 2% cash discount.

a.       Determine the number of units of product K to be manufactured in May.

b.      Compute the May cash outlay for purchases of raw material A.

 


July

August

September

Beginning cash balance

$10,000

$ ?

$ ?

Add: Cash receipts

50,000

63,000

71,000

Deduct: Cash payments

-64,000

-58,000

-64,000

Cash excess (deficiency) before financing

($4,000)

$ ?

$ ?

Financing




Borrowing to maintain minimum balance

?

?

?

Principal repayment

?

?

?

Interest payment

?

?

?

Ending cash balance

$ ?

$ ?

$ ?

 

 

 

 

 

 

 


Abbreviated cash budget; financing emphasis

An abbreviated cash budget for Big Chuck Enterprises follows.

Big Chuck wishes to maintain a $10,000 minimum cash balance at all times. Additional financing is available (and retired) in $1,000 multiples at a 12% interest rate. Assume that borrowings take place at the beginning of the month; retirements, in contrast, occur at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid.

a.       Find the unknowns in Big Chuck's abbreviated cash budget.

b.      Determine the outstanding loan balance as of September 30, after any repayments have been made.

Reference no: EM13488659

Questions Cloud

Prepare a forecasted balance sheet for the months : Prepare a budgeted income statement, under absorption costing for Mile-High for the months of April, May and June assuming that Mile High opts to use the variable delivery service.
Find direction of the final velocity of the composite object : An object with a mass of 3.00 kg, moving with an initial velocity of 5.00i m/s, find the direction of the final velocity of the composite object
Define comprehensive budgeting : Watson uses four units of direct material in each finished unit. The direct material price has been stable and is expected to remain so over the next six months. Management wants to maintain the ending direct materials inventory at 60% of the f..
Find the average power generated by the horn : A train sounds its horn as it approaches an intersection. The horn can just be heard at a level of 56 dB by an observer 10 km away. What is the average power generated by the horn
Find the unknowns in big chucks abbreviated cash budget : Determine the outstanding loan balance as of September 30, after any repayments have been made.
Determine the intensity level of the infrasound : There is evidence that elephants communicate via infrasound, generating rumbling vocalizations as low as 14 Hz that can travel up to 10 km. Determine the intensity level of the infrasound
Prepare a schedule of cash collections : Sugarland Company sells a single product and anticipates opening a new facility in Charlotte on May 1 of the current year. Expected sales during the first three months of activity are: May, $60,000; June, $80,000; and July, $85,000.
Calculate the intensity of the sound wave emitted : The toadfish makes use of resonance in a closed tube to produce very loud sounds. Calculate the intensity of the sound wave emitted
What is the amount of unrestricted cash : What is the amount of unrestricted Cash and Investments and what is the amount restricted Cash and Investments

Reviews

Write a Review

Financial Accounting Questions & Answers

  Determine the amount of the payment

Jonas won a lottery that will pay him $200,000 at the end of each of the next twenty years. Zebra Finance has offered to purchase the payment stream for $2,718,000. What interest rate (to the nearest percent) was used to determine the amount of t..

  What is relationship between organizational needs analysis

What is the relationship between organizational needs analysis and strategic planning? How can tying HRD programs to an organizations strategic plan make it easier to justify requests for resources?

  Explain change if the government decides

Explain how does the answer to requirement change if the government decides to depreciate this asset over a 10-year period using straight-line depreciation?

  What should be the carrying value of sullivan inventory

What should be the carrying value of Sullivan's inventory if the company prepares its financial statements according to International Financial Reporting Standards?

  Question using your topics and the literature review

question using your topics and the literature review prepare 3 to 5 possible topic areas of interest. these topics

  Operating data for gallup corporation are presented

operating data for gallup corporation are presented below.nbsp20092008sales750000600000cost of goods

  Illustrate what is the break-even point in units if variable

If fixed costs are $561,000 and the unit contribution margin is $8.00, illustrate what is the break-even point in units if variable costs are decreased by $.50 a unit?

  What amount of overhead will be assigned

Refer to the above data. If Riverview applies overhead using a predetermined rate based on machine-hours, what amount of overhead will be assigned to a unit of output which requires 0.5 machine hours and 0.25 labor hours to complete?

  Required write a report to the client geolab exploration

required write a report to the client geolab exploration limited which covers the followinga. a two-column common-size

  Evaluate the collins'' debt ratio

Impact of change in credit policy on the debt ratio - what will Collins' debt ratio be after the change in DSO is reflected in the balance sheet?

  Determine an estimate of total maintenance cost

Using the high-low method, determine an estimate of total maintenance cost for a month in which production is expected to be 45,000 units.

  What are the two methods that might be used to record

What are the two methods that might be used to record infrastructure expense from year to year? How is the accounting different under the two methods?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd