Compute the budgeted dollar amount of inventory

Assignment Help Cost Accounting
Reference no: EM13488596

1. All sales at Meeks Company, a wholesaler, are made on credit. Experience has shown that 70% of the accounts receivable are collected in the month of the sale, 26% are collected in the month following the sale, and the remaining 4% are uncollectible. Actual sales for March and budgeted sales for the following four months are given below:

 

March (actual sales)

$200,000

 

April

$300,000

 

May

$500,000

 

June

$700,000

 

July

$400,000

The company's cost of goods sold is equal to 60% of sales. All purchases of inventory are made on credit. Meeks Company pays for one half of a month's purchases in the month of purchase, and the other half in the month following purchase. The company requires that end-of-month inventories be equal to 25% of the cost of goods sold for the next month.

Required:

a. Compute the amount of cash, in total, which the company can expect to collect in May.

b. Compute the budgeted dollar amount of inventory which the company should have on hand at the end of April.

c. Compute the amount of inventory that the company should purchase during the months of May and June.

d. Compute the amount of cash payments that will be made to suppliers during June for purchases of inventory.

2. The Fraley Company, a merchandising firm, has planned the following sales for the next four months:

 

 

March

April

May

June

 

 

Total budgeted sales

$50,000

$70,000

$90,000

$60,000

 

Sales are made 40% for cash and 60% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern:

 

Month of sale

70%

 

 

First month following month of sale

20%

 

 

Second month following month of sale

8%

 

 

Uncollectible

2%

 










The company requires a minimum cash balance of $4,000 to start a month.

Required:

a. Compute the budgeted cash receipts for June.

b. Assume the following budgeted data for June:

 

Purchases

$52,000

 

Selling and administrative expenses

$10,000

 

Depreciation

$8,000

 

Equipment purchases

$15,000

 

Cash balance, beginning of June

$6,000

Using this data, along with your answer to part (1) above, prepare a cash budget in good form for June. Clearly show any borrowing needed during the month. The company can borrow in any dollar amount, but will not pay any interest until the following month.

Reference no: EM13488596

Questions Cloud

Compute the amount of cash in total : Compute the amount of cash, in total, which the company can expect to collect in May and compute the budgeted dollar amount of inventory which the company should have on hand at the end of April.
State what is the specific heat for the metal : It takes 51.0j to raise the temperature of an 11.4g piece of unknown metal from 13.0c to 25.0c. What is the specific heat for the metal
How the rule changed and what are things that changed : What is your view, giving a rational explanation to your view (you may use other sources to support your view, properly referencing). Why do you think that these measures were introduced?
Find how many units of angular momentum does it have : If you twirl a small 9.0-g wooden ball in a circle at 3.0 revolutions per second on a light 11-cm string, approximately how many units of angular momentum does it have
Compute the budgeted dollar amount of inventory : Compute the amount of cash, in total, which the company can expect to collect in May and compute the budgeted dollar amount of inventory which the company should have on hand at the end of April.
Explain both ends vibrates at resonant frequencies : A 1.6-m-long string fixed at both ends vibrates at resonant frequencies of 708 Hz and 1062 Hz, with no other resonant frequency between these values.
What is the distance of the object from the ship : A ship on the surface of the ocean receives a sonar echo back from an underwater object. What is the distance of the object from the ship
What is the increase in the entropy of the universe : On a cold day, 28100 J of heat leaks out of a house. The inside temperature is 19.0° C, What is the increase in the entropy of the universe that this heat loss produces
Explain dehydration of cis- and trans-4-methylcyclohexanol : what kind of mechanism can better account for the product mixture obtained from the dehydration of cis- and trans-4-methylcyclohexanol: E1, E2, or a combination of the two

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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