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.
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.)
please solve within 30 minutes.
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)
Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs thebusiness $30 to place a single order.The maximum number of units sold for any one week is 150 and minimum sales 80 units. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. TheEOQ model is appropriate.i) What is the cost minimizing solution for this product each year?ii)Determine the re-order level, minimum inventory level and maximum inventory level for the product.
Blossom Company sells 320 units of its products for $20 each to Wildhorse inc. for cash. Blossom allows Wildhorse to return any unused product within 30 days and receive a full refund. The cost of each product is $11. To determine the transaction price, Blossom decides that the approach that is most predictive of the amount of consideration to which it will be entitled is the probability weighted amount. Using the probability-weighted amount. Blossom estimates that (1) 7 products will be returned, and (2) the returned products are expected to be resold at a profit. Prepare the journal entries for Blossom at the time of the sale to Wildhorse including any expected returns. The company follows IFRS. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter "0" for the amounts. List all debit entries before credit entries.) Account Titles and Explanation Cash (To record…