{"id":99281,"date":"2022-10-13T01:34:06","date_gmt":"2022-10-13T01:34:06","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/your-company-assembles-five-different-models-of-a-motor-scooter-that\/"},"modified":"2022-10-13T01:34:06","modified_gmt":"2022-10-13T01:34:06","slug":"your-company-assembles-five-different-models-of-a-motor-scooter-that","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/your-company-assembles-five-different-models-of-a-motor-scooter-that\/","title":{"rendered":"Your company assembles five different models of a motor scooter that"},"content":{"rendered":"
\n

MGT655 Week 8 chapter 16 and 20 tutorial in excel<\/p>\n

\u00a0<\/p>\n

Objective Question 12; Chapter 16 \u2013 MGT-655<\/span><\/p>\n

12. Your company assembles five different models of a motor scooter that is sold in specialty<\/span> stores in the United States. The company uses the same engine for all five models. You<\/span> have been given the assignment of choosing a supplier for these engines for the coming<\/span> year. Due to the size of your warehouse and other administrative restrictions, you must<\/span> order the engines in lot sizes of 1,000 each. Because of the unique characteristics of the<\/span> engine, special tooling is needed during the manufacturing process for which you agree<\/span> to reimburse the supplier. Your assistant has obtained quotes from two reliable engine<\/span> suppliers and you need to decide which to use. The following data have been collected:<\/span><\/p>\n

Requirements (annual forecast)<\/span><\/p>\n

Weight per engine<\/span><\/p>\n

Order processing cost<\/span><\/p>\n

Inventory carry cost<\/span><\/p>\n

12,000 units<\/span><\/p>\n

22 pounds<\/span><\/p>\n

$125 per order<\/span><\/p>\n

20 percent of the average value of inventory per year<\/span><\/p>\n

Note: <\/span><\/em>Assume that half of lot size is in inventory on average (1,000\/2 5 500 units).<\/span><\/p>\n

Two qualified suppliers have submitted the following quotations:<\/span><\/p>\n

Order Quantity<\/span><\/p>\n

Supplier 1<\/span><\/p>\n

Unit Price<\/span><\/p>\n

Supplier 2<\/span><\/p>\n

Unit Price<\/span><\/p>\n

1 to 1,499 units\/order<\/span><\/p>\n

1,500 to 2,999 units\/order<\/span><\/p>\n

3,0001 units\/order<\/span><\/p>\n

Tooling costs<\/span><\/p>\n

Distance<\/span><\/p>\n

$510.00<\/span><\/p>\n

500.00<\/span><\/p>\n

490.00<\/span><\/p>\n

$22,000<\/span><\/p>\n

125 mi les<\/span><\/p>\n

$505.00<\/span><\/p>\n

$505.00<\/span><\/p>\n

488.00<\/span><\/p>\n

$20,000<\/span><\/p>\n

100 mi les<\/span><\/p>\n

Your assistant has obtained the following freight rates from your carrier:<\/span><\/p>\n

Truckload (40,000 lbs. each load):<\/span><\/p>\n

Less-than-truckload:<\/span><\/p>\n

$0.80 per ton-mile<\/span><\/p>\n

$1.20 per ton-mile<\/span><\/p>\n

Note: <\/span><\/em>Per ton-mile 5 2,000 lbs. per mile.<\/span><\/p>\n

a. <\/span><\/em>Perform a total cost of ownership analysis and select a supplier.<\/span><\/p>\n

b. <\/span><\/em>Would it make economic sense to order in truckload quantities? Would your supplier selection change if you ordered truckload quantities?<\/span><\/p>\n

Objective Question 17<\/span><\/p>\n

U.S. Airfilter has hired you as a supply chain consultant. The company makes air fi lters<\/span> for residential heating and air-conditioning systems. These filters are made in a single<\/span> plant located in Louisville, Kentucky, in the United States. They are distributed to retailers<\/span> through wholesale centers in 100 locations in the United States, Canada, and Europe.<\/span> You have collected the following data relating to the value of inventory in the U.S. Airfi lter<\/span><\/p>\n

supply chain:<\/span><\/p>\n

Quarter 1<\/span><\/p>\n

(January<\/span><\/p>\n

through March)<\/span><\/p>\n

Quarter 2<\/span><\/p>\n

(April<\/span><\/p>\n

through June)<\/span><\/p>\n

Quarter 3<\/span><\/p>\n

(July through<\/span><\/p>\n

September)<\/span><\/p>\n

Quarter 4<\/span><\/p>\n

(October through<\/span><\/p>\n

December)<\/span><\/p>\n

Sales (total quarter):<\/span><\/p>\n

United States<\/span><\/p>\n

Canada<\/span><\/p>\n

Europe<\/span><\/p>\n

300<\/span><\/p>\n

75<\/span><\/p>\n

30<\/span><\/p>\n

350<\/span><\/p>\n

60<\/span><\/p>\n

33<\/span><\/p>\n

405<\/span><\/p>\n

75<\/span><\/p>\n

20<\/span><\/p>\n

375<\/span><\/p>\n

70<\/span><\/p>\n

15<\/span><\/p>\n

Cost of goods<\/span><\/p>\n

sold (total quarter)<\/span><\/p>\n

280 295 340 350<\/span><\/p>\n

Raw materials at<\/span><\/p>\n

the Louisville<\/span><\/p>\n

plant (end-of-quarter)<\/span><\/p>\n

50 40 55 60<\/span><\/p>\n

Work-in-process<\/span><\/p>\n

and fi nished<\/span><\/p>\n

goods at the<\/span><\/p>\n

Louisville plant<\/span><\/p>\n

(end-of-quarter)<\/span><\/p>\n

100 105 120 150<\/span><\/p>\n

Distribution center<\/span><\/p>\n

inventory (end-of-quarter):<\/span><\/p>\n

United States<\/span><\/p>\n

Canada<\/span><\/p>\n

Europe<\/span><\/p>\n

25<\/span><\/p>\n

10<\/span><\/p>\n

5<\/span><\/p>\n

27<\/span><\/p>\n

11<\/span><\/p>\n

4<\/span><\/p>\n

23<\/span><\/p>\n

15<\/span><\/p>\n

5<\/span><\/p>\n

30<\/span><\/p>\n

16<\/span><\/p>\n

5<\/span><\/p>\n

All amounts in millions of U.S. dollars.<\/span><\/p>\n

a. <\/span><\/em>What is the average inventory turnover for the fi rm?<\/span><\/p>\n

b. <\/span><\/em>If you were given the assignment to increase inventory turnover, what would you<\/span> focus on? Why?<\/span><\/p>\n

c. <\/span><\/em>The company reported that it used $500M worth of raw material during the year. On<\/span> average, how many weeks of supply of raw material are on hand at the factory?<\/span><\/p>\n

\u00a0<\/span><\/p>\n

Objective Questions for chapter 20, Operations and Supply Change Management \u2013 MGT-655<\/span><\/p>\n

17. Jill\u2019s Job Shop buys two parts (Tegdiws and Widgets) for use in its production system<\/span> from two different suppliers. The parts are needed throughout the entire 52-week year.<\/span> Tegdiws are used at a relatively constant rate and are ordered whenever the remaining<\/span> quantity drops to the reorder level. Widgets are ordered from a supplier who stops by<\/span> every three weeks. Data for both products are as follows:<\/span><\/p>\n

Item Tegdiw Widget<\/span><\/p>\n

Annual demand<\/span><\/p>\n

Holding cost (% of item cost)<\/span><\/p>\n

Setup or order cost<\/span><\/p>\n

Lead time<\/span><\/p>\n

Safety stock<\/span><\/p>\n

Item cost<\/span><\/p>\n

10,000<\/span><\/p>\n

20%<\/span><\/p>\n

$150.00<\/span><\/p>\n

4 weeks<\/span><\/p>\n

55 units<\/span><\/p>\n

$10.00<\/span><\/p>\n

5,000<\/span><\/p>\n

20%<\/span><\/p>\n

$25.00<\/span><\/p>\n

1 week<\/span><\/p>\n

5 units<\/span><\/p>\n

$2.00<\/span><\/p>\n

a. <\/span><\/em>What is the inventory control system for Tegdiws? That is, what is the reorder quantity<\/span> and what is the reorder point?<\/span><\/p>\n

b. <\/span><\/em>What is the inventory control system for Widgets?<\/span><\/p>\n

\u00a0<\/span><\/p>\n

21. Item X is a standard item stocked in a company\u2019s inventory of component parts. Each year<\/span> the firm, on a random basis, uses about 2,000 of item X, which costs $25 each. Storage<\/span> costs, which include insurance and cost of capital, amount to $5 per unit of average inventory.<\/span> Every time an order is placed for more of item X, it costs $10.<\/span><\/p>\n

a. <\/span><\/em>Whenever item X is ordered, what should the order size be?<\/span><\/p>\n

b. <\/span><\/em>What is the annual cost for ordering item X?<\/span><\/p>\n

c. <\/span><\/em>What is the annual cost for storing item X?<\/span><\/p>\n

\u00a0<\/span><\/p>\n

40. In the past, Taylor Industries has used a fi xed\u2013time period inventory system that involved<\/span> taking a complete inventory count of all items each month. However, increasing labor<\/span> costs are forcing Taylor Industries to examine alternative ways to reduce the amount of<\/span> labor involved in inventory stockrooms, yet without increasing other costs, such as shortage<\/span> costs. Here is a random sample of 20 of Taylor\u2019s items.<\/span><\/p>\n

Item<\/span><\/p>\n

Number<\/span><\/p>\n

Annual<\/span><\/p>\n

Usage<\/span><\/p>\n

Item<\/span><\/p>\n

Number<\/span><\/p>\n

Annual<\/span><\/p>\n

Usage<\/span><\/p>\n

1<\/span><\/p>\n

2<\/span><\/p>\n

3<\/span><\/p>\n

4<\/span><\/p>\n

5<\/span><\/p>\n

6<\/span><\/p>\n

7<\/span><\/p>\n

8<\/span><\/p>\n

9<\/span><\/p>\n

10<\/span><\/p>\n

$ 1,500<\/span><\/p>\n

12,000<\/span><\/p>\n

2,200<\/span><\/p>\n

50,000<\/span><\/p>\n

9,600<\/span><\/p>\n

750<\/span><\/p>\n

2,000<\/span><\/p>\n

11,000<\/span><\/p>\n

800<\/span><\/p>\n

15,000<\/span><\/p>\n

11<\/span><\/p>\n

12<\/span><\/p>\n

13<\/span><\/p>\n

14<\/span><\/p>\n

15<\/span><\/p>\n

16<\/span><\/p>\n

17<\/span><\/p>\n

18<\/span><\/p>\n

19<\/span><\/p>\n

20<\/span><\/p>\n

$13,000<\/span><\/p>\n

600<\/span><\/p>\n

42,000<\/span><\/p>\n

9,900<\/span><\/p>\n

1,200<\/span><\/p>\n

10,200<\/span><\/p>\n

4,000<\/span><\/p>\n

61,000<\/span><\/p>\n

3,500<\/span><\/p>\n

2,900<\/span><\/p>\n

a. <\/span><\/em>What would you recommend Taylor do to cut back its labor cost? (Illustrate using an<\/span> ABC plan.)<\/span><\/p>\n

b. <\/span><\/em>Item 15 is critical to continued operations. How would you recommend it be classified?<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

MGT655 Week 8 chapter 16 and 20 tutorial in excel \u00a0 Objective Question 12; Chapter 16 \u2013 MGT-655 12. Your company assembles five different models of a motor scooter that is sold in specialty stores in the United States. The company uses the same engine for all five models. You have been given the assignment […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-99281","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/99281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=99281"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/99281\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=99281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=99281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=99281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}