Question

In: Accounting

The following basic information is provided and applies to all questions below. Currently, the annual demand...

The following basic information is provided and applies to all questions below. Currently, the annual demand for a product is 1000 units, the setup (i.e., ordering cost) per order is $45, and the holding cost is 80 cents per item per year.

Q1. Calculate the EOQ for the current year using the basic information provided. With other things constant, demand is expected to grow by 15% for each of the next five years. For next year, this means that demand is assumed to be 1000 * 1.15.

Use the SHORTCUT method discussed in class to provide the EOQ for each of the next five years. Label these EOQ(1), EOQ(2),….EOQ(5). For the final year, compute EOQ(5) using the LONG method (by computing the expected demand and substituting in the EOQ formula) and compare to your answer obtained by the SHORTCUT method. Keep at least four places of decimal in your calculations (you can keep 2 places for the calculated EOQ)

Solutions

Expert Solution

Economic Order Quantity (EOQ)

It is the ideal order quantity a company should purchases to minimize inventory costs such as holding cost, storage costs, and other costs. This EOQ Model developed by Ford W. Harrris in the year 1913 and has been redifined over the years.

EOQ help to minimize the total cost relates to ordering cost, receiving and the holding cost.

From the EOQ firm must reduce the cost by ordering the product at once and utilize the cost reduction.

EOQ is determined by multiply the demand of the product per year to th eordering cost and divide to the holding cost and taking square of all, we get EOQ.

Below requirement attached for the working of EOQ FOR THE NEXT FIVE year with every time demand changes by 15%.

Ordering cost is $45 and the holding cost is 80%.

A s the demand increases EOQ ALSO INCREASES.

Solution Attached:


Related Solutions

Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,600 $ 17,500 Beginning work in process inventory 18,000 20,550 Beginning raw materials inventory (direct materials) 7,400 12,150 Rental cost on factory equipment 30,500 24,700 Direct labor 21,200 41,000 Ending finished goods inventory 17,150 14,100 Ending work in process inventory 25,900 20,200 Ending raw materials inventory 7,100 7,600 Factory...
Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,600 $ 17,500 Beginning work in process inventory 18,000 20,550 Beginning raw materials inventory (direct materials) 7,400 12,150 Rental cost on factory equipment 30,500 24,700 Direct labor 21,200 41,000 Ending finished goods inventory 17,150 14,100 Ending work in process inventory 25,900 20,200 Ending raw materials inventory 7,100 7,600 Factory...
Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,700 $ 19,600 Beginning work in process inventory 18,800 22,800 Beginning raw materials inventory 7,200 13,200 Rental cost on factory equipment 31,500 24,100 Direct labor 20,800 37,800 Ending finished goods inventory 19,250 13,100 Ending work in process inventory 23,800 21,400 Ending raw materials inventory 6,300 9,800 Factory utilities 10,950...
Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,200 $ 17,350 Beginning work in process inventory 15,600 23,400 Beginning raw materials inventory 7,300 11,550 Rental cost on factory equipment 29,750 24,400 Direct labor 24,800 41,400 Ending finished goods inventory 20,900 16,200 Ending work in process inventory 22,300 16,600 Ending raw materials inventory 6,400 7,400 Factory utilities 14,250...
Required information [The following information applies to the questions displayed below.] The following data is provided...
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,700 $ 16,600 Beginning work in process inventory 18,000 23,550 Beginning raw materials inventory 11,500 13,350 Rental cost on factory equipment 27,250 26,950 Direct labor 20,600 43,000 Ending finished goods inventory 20,000 13,500 Ending work in process inventory 25,300 17,200 Ending raw materials inventory 6,200 8,000 Factory utilities 11,550...
[The following information applies to the questions displayed below.]fNotes with important tax information are provided below...
[The following information applies to the questions displayed below.]fNotes with important tax information are provided below XYZ is a calendar-year corporation that began business on January 1, 2017. For 2018, it reported the following information in its current year audited income statement. Notes with important tax information are provided below. Exhibit 16-6. XYZ corp. Book Income Income statement For current year Revenue from sales $ 40,000,000 Cost of Goods Sold (27,000,000 ) Gross profit $ 13,000,000 Other income: Income from...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 13,800 $ 16,000 Beginning work in process inventory 17,300 23,400 Beginning raw materials inventory (direct materials) 8,100 10,500 Rental cost on factory equipment 28,750 24,250 Direct labor 21,000 36,200 Ending finished goods inventory 20,300 16,000 Ending work in process inventory 22,300 17,000 Ending raw materials inventory 6,600 9,400 Factory utilities 12,150...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,500 $ 16,300 Beginning work in process inventory 15,900 19,650 Beginning raw materials inventory 10,500 14,400 Rental cost on factory equipment 28,750 26,500 Direct labor 25,000 42,600 Ending finished goods inventory 20,000 13,000 Ending work in process inventory 23,500 19,600 Ending raw materials inventory 7,200 8,800 Factory utilities 9,150 12,250 Factory...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,500 $ 16,300 Beginning work in process inventory 15,900 19,650 Beginning raw materials inventory 10,500 14,400 Rental cost on factory equipment 28,750 26,500 Direct labor 25,000 42,600 Ending finished goods inventory 20,000 13,000 Ending work in process inventory 23,500 19,600 Ending raw materials inventory 7,200 8,800 Factory utilities 9,150 12,250 Factory...
[The following information applies to the questions displayed below.] The following data is provided for Garcon...
[The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,000 $ 19,450 Beginning work in process inventory 16,300 20,100 Beginning raw materials inventory (direct materials) 8,900 9,450 Rental cost on factory equipment 32,750 24,850 Direct labor 24,400 41,000 Ending finished goods inventory 21,050 13,400 Ending work in process inventory 25,000 19,400 Ending raw materials inventory 7,100 8,200 Factory utilities 13,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT