Question

In: Accounting

136. Schrank Company is trying to decide how many units of merchandise to order each month....

136. Schrank Company is trying to decide how many units of merchandise to order each month. The company's policy is to have 25% of the next month's sales in inventory at the end of each month. Projected sales for August, September, and October are 44,000 units, 34,000 units, and 54,000 units, respectively. How many units must be purchased in September?

136B. The sales budget for Modesto Corp. shows that 21,100 units of Product A and 23,100 units of Product B are going to be sold for prices of $11.10 and $13.10, respectively. The desired ending inventory of Product A is 10% higher than its beginning inventory of 3,100 units. The beginning inventory of Product B is 3,600 units. The desired ending inventory of B is 4,100 units. Budgeted purchases of Product A for the year would be:

Solutions

Expert Solution

Ans:

136.) Sales budget by a company is prepared to get idea about their estimated sales, so that they can estimates purchases to be made for raw material or inventory. Which help them to identify Working Capital requirement for smooth running of business.

Prjected Sale of October Month: 54000 units

Company's Policy towards Closing Inventory : 25% of following Month sales.

So, Closing Inventory for September Month: 54000*25% = 13,500

Projected Sales of September Month = 34,000 units

Opening Inventory of September Month = 34000*25% = 8500 units

Units must be purchased in September = Closing Inventory+ Sales- Opening Inventory.

=13500+34000-8500= 39000 units

136 b.)

Budgeted Purchase for Product A will be:

Desired Closing Inventory = 3100+10% of 3100 = 3410

Estimates Sales= 21,100 units

Opening Inventory = 3100

Budgeted Purchase for Product A = Closing Inventory+ Estimated Sales- Opening Invetory

= 3,410+21,100-3,100 = 21,410 units.


Related Solutions

A toy store must decide on how many bears to order for the next year. Each...
A toy store must decide on how many bears to order for the next year. Each bear is sold for $6 and costs $3. After January 1st 2019, any unsold bears are returned to the publisher for a refund of $1 each. If demand is normally distributed with a mean of 3000 and a standard deviation of 500, how many bears should the toy store order?
The builder of a new movie theater complex is trying to decide how many screens she...
The builder of a new movie theater complex is trying to decide how many screens she wants. Below are her estimates of the number of patrons the complex will attract each year, depending on the number of screens available. Number of screens Total number of patrons 1 40,000 2 65,000 3 85,000 4 100,000 5 110,000 After paying the movie distributors and meeting all other noninterest expenses, the owner expects to net $2.5 per ticket sold. Construction costs are $1,000,000...
The builder of a new movie theater complex is trying to decide how many screens she...
The builder of a new movie theater complex is trying to decide how many screens she wants. Below are her estimates of the number of patrons the complex will attract each year, depending on the number of screens available. Number of screens Total number of patrons 1 40,000 2 75,000 3 105,000 4 130,000 5 150,000 After paying the movie distributors and meeting all other noninterest expenses, the owner expects to net $2.5 per ticket sold. Construction costs are $1,000,000...
The builder of a new movie theater is trying to decide how many screens she wants....
The builder of a new movie theater is trying to decide how many screens she wants. Below are her estimate of the number of patrons the complex will attract each year depending on the number of screens available. Number of screens: Total number of patrons 1 50,000 2 95,000 3 135,000 4 170,000 5 195,000 The owner expects to net $2 per ticket sold. Construction costs are $1,000,000 per screen. The screen can always be resold for $1,000,000 at the...
You are trying to decide between a 48-month loan and a 60-month car loan. If the...
You are trying to decide between a 48-month loan and a 60-month car loan. If the loan is for $22,000 at 6% APR, how much more per month is the monthly payment of the shorter loan?
John from One Source Credit is trying to decide how many machines to buy. The processing...
John from One Source Credit is trying to decide how many machines to buy. The processing time is 7.5 minutes per customer. One machine will have total fixed costs of $5,300 per day, two machines will have total fixed costs of $9,800 per day. Variable costs are $40 per customer, revenue is $80 per customer. 1. Determine the break-even point for one machine. a. 89 Customers per Day b. 133 Customers per Day c. 128 Customers per Day 2. Determine...
:    A concert promoter needs to decide how many concert T- shirt to order supplied with...
:    A concert promoter needs to decide how many concert T- shirt to order supplied with          its logo name on the front side of T-shirt. The profit on each one sold at the concert is 50 L.E. and any unsold T-shirt and returned to the supplied company will cause a loss of 30 L.E for the promoter. Demand is uncertain but is estimated to be between 200 to 1000 T-shirt. The probabilities of different demand levels are as follows: Demand...
A local gift shop is trying to determine how many photos frames to order. The shop...
A local gift shop is trying to determine how many photos frames to order. The shop feels it will sell approximately 800 photos frames in the next year at a unit price of R18.00.The wholesale price that the store pays per photo frame is R12.00. The cost of carrying one photo frame is estimated at R1.60 per year, while ordering costs are estimated at 825.00 per batch ordered. REQUIRED (a) Explain the meaning of economic order quantity (EOQ) and reorder...
Lemington’s is trying to determine how many Jean Hudson dresses to order for the spring season....
Lemington’s is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemington’s works as follows. At the beginning of the season, Lemington’s reserves x units of capacity. xxLemington’s must take delivery for at least 0.8xdresses and can, if desired, take delivery on up to xdresses. Each dress sells for $160 and...
As with other products, Einstein faces the decision of how many GiggleBloxx units to order for...
As with other products, Einstein faces the decision of how many GiggleBloxx units to order for the coming holiday season. Members of the management team suggested order quantities of 25,000, 36,000, 48,000, or 65,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning the market potential. The product management team asks you for an analysis of the stock-out probabilities for various order quantities, an estimate of the profit potential, and help with making an order quantity recommendation....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT