The cost of the speaker depends on the order size

Assignment Help Operation Management

Reference no: EM131273092

A TV manufacturing company uses speakers at the rate of 8000/mo. When it places an order for speakers it incurs a fixed cost of $1200. The monthly interest rate for keeping a speaker in stock is assessed at 1%/mo. The cost of the speaker depends on the order size. If less than 1000 speakers are ordered the cost is $11 each. When the order size is between 1000 and 10,000 the cost is $10.50/unit. For order sizes between 10,000 and 30,000 the cost is $10 per unit. For order quantities between 30,000 and 80,000 the cost drops to $9.50. Beyond 80,000 the cost is $9.25. Determine the optimum order size and time between orders if shortages are not allowed.

Please use excel to solve this problem. Show all cell formulas and parameters used.

Reference no: EM131273092

Questions Cloud

What is profitability of product-effect on the bottom line : Select an existing health care related product or service: What is the target market of the product or service selected? After selecting a current, common health care brand, address the following: What images or thoughts do you relate to that brand? ..

Exercise as well as preliminary feasibility study : You are an engineer for a fire alarm technology company. A representative of a manufacturing company comes to you saying they want to have their companies facilities outfitted with fire detection and protection technology (for now that's all you know..

Periodic or perpetual-lifo-fifo-specific identification : Where does Rue 21 sell its inventory? Retail or wholesale? In limited locations or throughout the world. Are there specific states or countries? What type of items does Rue 21 have in inventory? List at least ten products. How does the company Rue 21..

Describe customer–centric approach to business : How does management in your organization compare to management at One Smooth Stone? Hofstede has suggested five dimensions of culture. Make up another different from any of Hofstede's dimensions. Describe “customer – centric” approach to business

The cost of the speaker depends on the order size : A TV manufacturing company uses speakers at the rate of 8000/mo. When it places an order for speakers it incurs a fixed cost of $1200. The monthly interest rate for keeping a speaker in stock is assessed at 1%/mo. The cost of the speaker depends on t..

What biblical connections can be made to the values : Compare the way the case at LTL Trucking reflects forgiveness with the way Scripture teaches us to forgive. What are the similarities and differences? How can leaders shape the way this concept is applied in the workplace? What biblical connections c..

Huffing and puffing their wares : The term puffing refers to a salesperson’s exaggerated claims as to the quality of goods offered for sale. The law assumes that most buyers or lessees know, or should know, that sellers and lessors traditionally have engaged in “huffing and puffing” ..

Life insurance policy to prospective customer : Sam was about to sell a $1 million life insurance policy to a prospective customer when he resigned from his position with Equity Life. Before resigning from the company, he had expended substantial amounts of company money and had utilized Equity’s..

Life insurance policy to a prospective customer : Sam was about to sell a $1 million life insurance policy to a prospective customer when he resigned from his position with Equity Life. Before resigning from the company, he had expended substantial amounts of company money and had utilized Equity’s..

User Account

All Pages