A firm has 200 units of a product in inventory. The forecasts of the demands are...

A firm has 200 units of a product in inventory. The forecasts of the demands are 40 units per week. An MPS quantity of 50 units is planned to arrive in period 2. Customer orders are 40 for period 1, 10 for period 2, and 50 for period 3. Present the computation to estimate the projected on-hand inventory at the end of period 3, and the result (for example, 500-400+10=110 units.)

Solutions

Expert Solution

Solution :

Product	On Hand	1	2	3
Forecast		40	40	40
Orders		40	10	50
Scheduled Receipts		0	50	0
Projected On Hand	200	160	200	150

keosha answered 2 years ago

Next > < Previous

Related Solutions

At the beginning of May, Williams Industries has 200 units of a product with a unit...

At the beginning of May, Williams Industries has 200 units of a product with a unit cost of $500. Its inventory records report the following transactions for the month of May: Units Unit Cost Total Cost Beginning Inventory 200 $500 $100,000 Purchase #1 250 $550 137,500 Purchase #2 100 $600 60,000 Purchase #3 60 $650 39,000 Total 610 $336,500 Williams sells 500 units in May. a) Compute the Cost of Goods Sold (COGS) for May for this product, assuming Hanna...

Sekhon company had a beginning inventory on January 1 of 200 units of product 4-18-15 at...

Sekhon company had a beginning inventory on January 1 of 200 units of product 4-18-15 at cost of $20 per unit. During the year, the following purchases were made. Mar. 15 500 units at $21, July 20 313 units at $22 Sept. 4 413 units at $27. Dec. 2. 125 units at $31 1250 units were sold. Sekhon Company uses a periodic inventory system. 1. Determine the cost of good available for sale. 2. Calculate average cost per unit. 3....

A profit-maximizing firm in a competitive market is currently producing 200 units of output. It has...

A profit-maximizing firm in a competitive market is currently producing 200 units of output. It has a marginal cost of $15, the average total cost of $10, and a fixed cost of $200 (a) What is its profit? (b) What is its average revenue? (c) What is its average variable cost?

A. A firm has the capacity to produce 988,272 units of a product each year. At...

A. A firm has the capacity to produce 988,272 units of a product each year. At present, it is operating at 24 percent of capacity. The firm's annual revenue is $1007128. Annual fixed costs are $599333 and the variable costs are $0.65 per unit. What s the firm's annual profit or loss? B. A firm has the capacity to produce 1,386,753 units of a product each year. At present, it is operating at 62 percent of capacity. The firm's annual...

The level of inventory of a manufactured product has increased by 8,260 units during a period....

The level of inventory of a manufactured product has increased by 8,260 units during a period. The following data are also available: Variable Fixed Unit manufacturing costs of the period $14 $6 Unit operating expenses of the period $3 $5 What would be the effect on income from operations if variable costing is used rather than absorption costing? a.$49,560 increase b.$90,860 increase c.$49,560 decrease d.$90,860 decrease A business operated at 100% of capacity during its first month and incurred the...

Your firm has recently received an order for 500 units priced at $200 each from a...

Your firm has recently received an order for 500 units priced at $200 each from a distributor in Toronto (Canada). To fill the order, you have two options: Import polyester from a supplier in Monterrey (Mexico) to your manufacturing plant in Nashville (USA). Transform the polyester into carpet (1 unit of polyester = 1 unit of carpet), then transport the carpet to Toronto. Doing this comes at the following costs: Price of polyester from your Mexican supplier: 500 MEX (pesos)...

The annual demand for a product is 1,000 units. The company orders 200 units each time...

The annual demand for a product is 1,000 units. The company orders 200 units each time an order is placed. The lead-time is 6 days, and the company has determined that 20 units should be held as a safety stock. There are 250 working days per year. What is the reorder point?

Firm XYZ has fixed indirect costs of £100,000,000. The firm produces 1,000,000 units of product ABC....

Firm XYZ has fixed indirect costs of £100,000,000. The firm produces 1,000,000 units of product ABC. Additionally, for each unit produced, £50 of variable indirect costs are also incurred. Further, each unit produced consumes 2 direct labour hours, 5 machine hours and £20 of direct materials. The cost of 1 labour hour is £12.50 and it costs £5 per hour to run the machines. The firm also manufactures other products. In total it spends £75,000,000 on direct labour and £125,000,000...

Let us suppose the demand at a firm is 200 units per month. The firm orders...

Let us suppose the demand at a firm is 200 units per month. The firm orders 80 units each time. How many times does the firm place an order per year? What is the average inventory level at this firm?

Below are the following inventory transactions for Deuce Hardware: Units Unit Cost Jan 1 Inventory 200...

Below are the following inventory transactions for Deuce Hardware: Units Unit Cost Jan 1 Inventory 200 $ 2.50 Mar 28 Purchase 500 $ 2.60 May 15 Purchase 300 $ 2.50 July 27 Purchase 200 $ 2.80 Sep 30 Purchase 400 $ 3.00 Dec 15 Purchase 200 $ 3.20 During the year, 1,100 units were sold at $6 each. The company uses the periodic inventory system. Calculate Ending Inventory and Cost of Goods Sold under each of the following: Average Cost...

Subjects