A carton manufacturer produces two sizes of carton for a fortune 100 logistics company. The logistics company has agreed to buy the cartons for next 12 months. The carton manufacturer now has tasked their operations manager to identify the number of cartons to produce for each size to achieve maximum revenue. When sold to the logistics company, carton A5 sells for 6 dollars a piece and carton C5 sells for 8 dollars a piece. The carton manufacturer has a labor hours capacity of 8,300 hours and budget for raw material limited to $ 185,580. Carton A5 utilizes 0.09 hours of labor and $2 of material cost per piece whereas, carton C5 utilizes 0.12 hours of labor and $2.75 of material cost per piece. Formulate a LP model and solve in excel solver to calculate the optimal quantities of each type leading to maximizing the revenue and satisfying all constraints.

A carton manufacturer produces two sizes of carton for a fortune 100 logistics company. The logistics company has agreed to buy the cartons for next 12 months. The carton manufacturer now has tasked their operations manager to identify the number of cartons to produce for each size to achieve maximum revenue. When sold to the logistics company, carton A5 sells for 6 dollars a piece and carton C5 sells for 8 dollars a piece. The carton manufacturer has a labor hours capacity of 8,300 hours and budget for raw material limited to $ 185,580. Carton A5 utilizes 0.09 hours of labor and $2 of material cost per piece whereas, carton C5 utilizes 0.12 hours of labor and $2.75 of material cost per piece. Formulate a LP model and solve in excel solver to calculate the optimal quantities of each type leading to maximizing the revenue and satisfying all constraints.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints

Section: Chapter Questions

Problem 7E: Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The...

See similar textbooks

Similar questions

Crane, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $30 and are sold for $40. Glass pitchers cost $26 and are sold for $47. All other costs are fixed at $280,800 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year. Crane, Inc., has just received a sales catalog from a new supplier that is offering plastic pitchers for $28. What would be the new contribution margin per unit if managers switched to the new supplier? What would be the new breakeven point if managers switched to the new supplier? (Use contribution margin per unit to calculate breakeven units. Round answers to 0 decimal places, e.g. 25,000.)
A hardware store sells paint that has a demand of 9,706 gallons per year. The store purchases the paint from a supplier for 11.2 dollars per gallon The unit holding cost per year is 24 percent of the unit purchase cost. while the ordering cost is 175 dollars per order. The paint supplier has a lead time of 10 days. What is the annual ordering cost if the store uses the order quantity of 2,103 gallons per order? Assume EOQ model is appropriate. Use at least 4 decimal places.
Jansen Crafters has the capacity to produce 50,000 oak shelves per year and is currently selling 44,000 shelves for $32 each. Curate Furniture approached Jansen about buying 1,200 shelves for bookshelves it is building and is willing to pay $26 for each shelf. No packaging will be required for the bulk order. Jansen usually packages shelves for Home Depot at a price of $1.50 per shelf. The $1.50 per shelf cost is included in the unit variable cost of $27, with annual fixed costs of $320,000. However, the $1.50 packaging cost will not apply in this case. The fixed costs will be unaffected by the special order and the company has the capacity to accept the order. Based on this information, what would be the profit if Jensen accepts the special order?
A sport store carries a shoe for men that sells an approximately 3,049 pairs per year. The store purchases the shoes from the manufacturer for $30.2 per pair. The order lead time is 12 days. It costs the store $58 to place and process an order. The annual carrying charge is 24 percent. Assume EOQ model is appropriate and 360 days a year. If the store uses an order quantity of 276 units per order, what is the annual ordering cost? Use at least 4 decimal places.
An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics. The annual demand is approximately 1,200 batteries. The supplier pays $28 for each battery and estimates that the annual holding cost is 30 percent of the battery’s value. It costs approximately $20 to place an order (managerial and clerical costs). The supplier currently orders 100 batteries per month. What is the economic order quantity? Based on your answer above, how many orders will be placed per year using the EOQ? Determine the ordering, handling, and total inventory costs for the EOQ. Determine the effective annualized cost of financing for the following credit terms, assuming that (1) discounts are not taken, (2) accounts are paid at the end of the credit period, and (3) use 365=day year: a. 1/10, n/30; b. 3/10, n/30; c. 3/10, n/60; d. 2/10, n/90
Jansen Crafters has the capacity to produce 50,000 oak shelves per year and is currently selling 44,000 shelves for $32 each. Cutrate Furniture approached Jansen about buying 1,200 shelves for bookcases it is building and is willing to pay $26 for each shelf. No packaging will be required for the bulk order. Jansen usually packages shelves for Home Depot at a price of $1.50 per shelf. The $1.50 per-shelf cost is included in the unit variable cost of $27, with annual fixed costs of $320,000. However, the $1.50 packaging cost will not apply in this case. The fixed costs will be unaffected by the special order and the company has the capacity to accept the order. Based on this information, what would be the profit if Jansen accepts the special order?A. Profits will decrease by $1,200.B. Profits will increase by $31,200.C. Profits will increase by $600.D. Profits will increase by $7,200.
Sunland, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $25 and are sold for $35. Glass pitchers cost $24 and are sold for $45. All other costs are fixed at $572,000 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year.
Rapido Quadcopters plans to sella standard quadoopter (toy drone) for $54 and a delue quadcopter for $74. Rapido purchases the standard quadcopter for $44 and the deluse quadcopter for $54. Management expects to sel wo dekove quadcopters for every three standard quadcopters The company's monthly foxed expenses are $11,200. How many of each type of quadcopter must Rapido sell monthly to breakeven? To eam $7,7007 First identity the formula to compute the sales in units at various levels of operating income using the contribubon margin approach (Abbreviations used Avg. average, and CM e contribution margin) Fied expenses Operating income Weighed-avg CM per unit Breakeven sales in units Next compute the weighted average contribution margin per unit. First identity the formula labols, then complete the calculations step by step Standard Sale price per unt Deduct Varable expense per unit Contribution margin per unit Sales mix in unts Contribution margin Weighted average contribution margin…
Crane, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $30 and are sold for $40. Glass pitchers cost $26 and are sold for $47. All other costs are fixed at $280,800 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year. How many pitchers of each type must be sold to break even in the coming year? (Use contribution margin per unit to calculate breakeven units.)
A microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. The annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. a) If the order quantity is 1000 gallons, what is the average inventory? b) If the order quantity is 1500 gallons, how many orders are placed each year? c) What is the EOQ quantity? d) If the order quantity is 2500 gallons, what is the sum of the ordering and holding costs PER GALLON? e) If orders are for the EOQ amount, what is the annual cost of the inventory system as a percentage of the annual purchase cost? f)If orders must be in integer multiples of 1000 gallons, how much should be ordered to minimize ordering and holding costs PER GALLON? g) A 3% purchase price discount is given if orders are for 8000 gallons or more. What would total annual costs (purchasing, ordering, and holding) be using this discount?
One of the bulk raw beverages, which Blanchard buys, is gin. Assume that the cost of purchasing enough raw gin for one case is $100. Each time they place an order their cost for processing the order is $20. The annual holding cost is 33% of item cost and demand for gin is 2500 cases per year. Calculate the EOQ for this product. If the lead-time is one day, what is the reorder point ROP? What is the annual total cost of this strategy? What is the average inventory? What is the inventory turnover? Please do fast ASAP fast
3. PHL assembles security monitors. It purchases 900 black-and-white cathode ray tubes per month at $80 each. Ordering costs are $120, and annual carrying costs are $20 per unit. - a) Determine the economic order quantity (2 points) - b) Find number of orders per year (1 point) - c) If the supplier offer a price of $79.5 per tube for ordering 1200 tubes in a lot, would you evaluate and advise PHL to take advantage of the offer? (2 points)