Question

A company Motorsports sells a new sports car. Here are the records of shipments and sales...

A company Motorsports sells a new sports car. Here are the records of shipments and sales for the six months of this year. The BOM inventory is the number of cars on hand just before the first business day of the month. Sales is the number of cars sold during the month, including new backorders. Received is the number of cars received on the first business day of the month.

Company inventory and sales records

Month

BOM inventory

Sales

Received

BO Cost

Holding

January

13

35

20

February

24

20

March

21

25

April

16

20

May

20

20

June

23

25

  1. Determine the BOM inventory for February through June.
    1. Customers are willing to backorder the sports car, but company gives a $2000 discount if the car has to be backordered. Calculate the backorder costs for each month and put them in the table.
    1. The holding cost for unsold cars is $1000 per car-month. Calculate the holding costs and put them in the table.
    1. What is the total cost of backorders and holding for company over the six-month period?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Question 4: Aggregate Planning Plan production for a four month period: June through to September. For...
Question 4: Aggregate Planning Plan production for a four month period: June through to September. For June and July you should produce to exact demand forecast. For August and September you should use overtime and inventory with a stable workforce. Stable means the number of workers needed for July will be held constant through September. However the Ministry of Labour regulations put a maximum of 5000 hours of overtime labour per month in August and September (Zero overtime in June...
B manufactures and sells equipment for amateur and professional competitors in equestrian sports (such as horse...
B manufactures and sells equipment for amateur and professional competitors in equestrian sports (such as horse racing, steeplechase, show jumping, and harness racing). The company's annual sales are $5.2 million, its gross profit is $1.4 million, and its purchases are $0.8 million. The company's credit sales are 83% of its total sales, where all customers pay within 30 days, and the remainder of the sales are paid for in cash. Payments to suppliers average 25 days, and the company's inventory...
A manufactures and sells equipment for amateur and professional competitors in equestrian sports (such as horse...
A manufactures and sells equipment for amateur and professional competitors in equestrian sports (such as horse racing, steeplechase, show jumping, and harness racing). The company's annual sales are $5.2 million, its gross profit is $1.4 million, and its purchases are $0.8 million. The company's credit sales are 83% of its total sales, where all customers pay within 30 days, and the remainder of the sales are paid for in cash. Payments to suppliers average 25 days, and the company's inventory...
Lucy works for an adventure sports company, Outdoor Adventures. The company runs ski and snowboard helicopter...
Lucy works for an adventure sports company, Outdoor Adventures. The company runs ski and snowboard helicopter trips in the winter and whitewater raft trips in the summer. The company has determined that transportation costs are a mixed cost that can be estimated based on the number of miles driven each month. Data from the previous 6 months are as follows: Month Miles Driven Total Cost January 2,400 $ 1,200 February 2,300 $ 1,100 March 2,150 $1,038 April 1,800 $  930 May...
A company had the following purchases and sales during its first year of operations: Purchases Sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales January: 10 units at $120 6 units February: 20 units at $125 5 units May: 15 units at $130 9 units September: 12 units at $135 8 units November: 10 units at $140 13 units On December 31, there were 26 units remaining in ending inventory. Using the periodic FIFO inventory costing method, what is the value of cost of goods sold? (Assume all...
A company had the following purchases and sales during its first year of operations:    Purchases  ...
A company had the following purchases and sales during its first year of operations:    Purchases   Sales January:   29 units at $215   20 units February:   39 units at $220   18 units May:   34 units at $225   22 units September:   31 units at $230   21 units November:   29 units at $235   37 units On December 31, there were 44 units remaining in ending inventory. Using the Perpetual LIFO inventory valuation method, what is the cost of the ending inventory? (Assume all...
Sales Mix and Break-Even Sales Dragon Sports Inc. manufactures and sells two products, baseball bats and...
Sales Mix and Break-Even Sales Dragon Sports Inc. manufactures and sells two products, baseball bats and baseball gloves. The fixed costs are $169,100, and the sales mix is 70% bats and 30% gloves. The unit selling price and the unit variable cost for each product are as follows: Products Unit Selling Price Unit Variable Cost Bats $40 $30 Gloves 100 60 a. Compute the break-even sales (units) for both products combined. units b. How many units of each product, baseball...