A retail company sells electronics products including mouse and keyboard. Mouse and keyboard are acquired from...

A retail company sells electronics products including mouse and keyboard. Mouse and keyboard are acquired from distinct suppliers. The monthly demand for a mouse is 2000, while the monthly demand for a keyboard is 1000 products. Mouse costs to company $12 and keyboard's cost are $18. The company has an annual holding cost of 20%, and the fixed shipment cost is $300. The procurement manager is not sure whether to order the mouse and keyboard separately or jointly. Assist with her decision making by calculating the following: 1) Optimal order size, 2) Optimal order frequency, 3) Cycle inventory, 4) Total cost of holding and ordering. Hint: Check the problem where products ordered and delivered separately vs. jointly.

Solve the problem using EXCEL.

Solutions

Expert Solution

Soution using Excel is as follows:

Ordered Separately

EXCEL FORMULA:

----------------------------------------------------------------------------------------------------------------

Ordered Jointly

EXCEL FORMULA:

-------------------------------------------------------------------------------------------

We see that the total cost of Joint ordering is lower. Therefore, the procurement manager should order jointly

keosha answered 6 days ago

Next > < Previous

Related Solutions

Roedel Electronics produces tablet computer accessories, including integrated keyboard tablet stands that connect a keyboard to...

Roedel Electronics produces tablet computer accessories, including integrated keyboard tablet stands that connect a keyboard to a tablet device and hold the device at a preferred angle for easy viewing and typing. Roedel produces two different sizes of integrated keyboard tablet stands, small and large. Each size uses the same keyboard attachment, but the stand consists of two different pieces, a top flap and a vertical stand that differ by size. Thus, a completed integrated keyboard tablet stand consists of...

Blooms Enterprise is a retail company that sells household electronics. The budget for the forthcoming period...

Blooms Enterprise is a retail company that sells household electronics. The budget for the forthcoming period January to March 2021 is to be prepared. Expectations for the forthcoming period include the following: a. Expected Statement of Financial Position as at 31 December 2020 $ $ ASSETS Non-current Assets Property Plant and Equipment (NBV) 1,344,500 Current Assets Inventory 346,500 Accounts Receivable 126,000 Marketable securities 30,000 Cash 353,000 855,500 2,200,000 EQUITIES AND LIABILIATIES Capital Share capital 1,000,000 Accumulated profits 216,200 1,216,200 Current Liabilities...

Blooms Enterprise Project Blooms Enterprise is a retail company that sells household electronics. The budget for...

Blooms Enterprise Project Blooms Enterprise is a retail company that sells household electronics. The budget for the forthcoming period January to March 2021 is to be prepared. Expectations for the forthcoming period include the following: Expected Statement of Financial Position as at 31 December 2020 $ $ ASSETS Non-current Assets Property Plant and Equipment (NBV) 1,344,500 Current Assets Inventory 346,500 Accounts Receivable 126,000 Marketable securities 30,000 Cash 353,000 855,500 2,200,000 EQUITIES AND LIABILIATIES Capital Share capital 1,000,000 Accumulated profits 216,200...

abulous is a retail company that sells specialized gardening products. The company is considering opening a...

abulous is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s operation. You have gathered the following information: October sales are estimated to be $500000 of which 45 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate...

Choice is a retail company that sells specialized gardening products. The company is considering opening a...

Choice is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s operation. You have gathered the following information: October sales are estimated to be $280000 of which 60 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate...

Choice is a retail company that sells specialized gardening products. The company is considering opening a...

Admire is a retail company that sells specialized gardening products. The company is considering opening a...

Admire is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s operation. You have gathered the following information: October sales are estimated to be $300000 of which 45 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate...

Before finalizing the design of a keyboard, an electronics company decided to conduct an experiment to...

Before finalizing the design of a keyboard, an electronics company decided to conduct an experiment to see the effect of two design choices (backlight: red vs. blue; product weight: heavy vs. light) on customers' attitude towards the product (measured on a scale of 1 to 7). Run the appropriate statistical test and at .05 level identify whether these design choices have an effect on consumers' attitude towards the product. Identify if there is a significant interaction effect (at .05 level)....

Company has grown from a local electronics retail store to one of leading manufacturers and distributor...

Company has grown from a local electronics retail store to one of leading manufacturers and distributor of navigation equipment in only five years. Today, Majid is meeting with the company’s head of marketing, Omar Al Mansoor, to discuss the development of a new product, the Map100, a new generation system with detailed Middle East road and sea area coverage for driving, boating, or plain walking applications. The new interface of the Map100 allows for an automatic update of the road...

Williams Products Inc. manufactures and sells a number of items, including school knapsacks. The company has...

Williams Products Inc. manufactures and sells a number of items, including school knapsacks. The company has been experiencing losses on the knapsacks for some time, as shown by the contribution format income statement below: WILLIAMS PRODUCTS INC. Income Statement—School Knapsacks For the Quarter Ended June 30 Sales $ 285,000 Variable expenses: Variable manufacturing expenses $ 79,800 Sales commissions 31,350 Shipping 8,550 Total variable expenses 119,700 Contribution margin 165,300 Fixed expenses: Salary of product-line manager 11,000 General factory overhead 56,800 *...

Subjects