In the packaging department of a large aircraft parts distributor, a fairly reliable estimate of packaging and processing costs can be determined by knowing the weight of an order. Thus the weight is a cost driver that accounts for a sizable fraction of the packaging and processing costs at this company. Data for the past 10 orders are given as follows: Packaging and Processing Costs ($), Y 97 109 88 86 123 114 112 102 107 86 Weight (Pounds), X 230 280 210 190 320 300 280 260 270 190 (A) Estimate the bo and b₁ coefficients, and determine the linear regression equation to fit these data. (B) What is the correlation coefficient (R) and what is the Pearson correlation coefficient (R²)? (C) If an order weighs 250 lbs, how much would it cost to package and process it?

In the packaging department of a large aircraft parts distributor, a fairly reliable estimate of packaging and processing costs can be determined by knowing the weight of an order. Thus the weight is a cost driver that accounts for a sizable fraction of the packaging and processing costs at this company. Data for the past 10 orders are given as follows: Packaging and Processing Costs ($), Y 97 109 88 86 123 114 112 102 107 86 Weight (Pounds), X 230 280 210 190 320 300 280 260 270 190 (A) Estimate the bo and b₁ coefficients, and determine the linear regression equation to fit these data. (B) What is the correlation coefficient (R) and what is the Pearson correlation coefficient (R²)? (C) If an order weighs 250 lbs, how much would it cost to package and process it?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Product D is stocked only at the AMC Chemical Company's Dallas warehouse and at the company's plant warehouse in Akron. The sales director has forecast product sales from the Dallas warehouse to be 40 units per week for the next 8 weeks. Product D is manufactured at the firm's Akron plant using 2 units of ingredient X per unit of product D. Suppose product D's actual sales at the Dallas warehouse in week 2 were 31 units. Again, all planned shipments/orders were released and expedite actions taken. What action would the master scheduler take on the basis of this information? In this situation, what modifications to the master production schedule might be taken? (4 points) Information: Ingredient X Projected available balance: 4 Units Safety stock quantity: 2 units Product D in Dallas Warehouse Product D in Plant Projected available balance: 85 Units Safety stock quantity: 5 units Lead time: 2 weeks Warehouse Projected available balance: 42 Units Safety stock quantity: 2 units Lead time:…
Inventory Management You are the store manager at a local branch of DigiLife, a large electronics retail chain. A new version of a popular consumer electronics device called the Amulet is coming out this year. It is your job to sell as many Amulets as you can while minimizing your costs in order to maximize your store's profits. Your Goal Earn $1,000,000 in net profits of Amulet sales.
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item Code 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 L. Houts Plastics Charlotte Inventory Levels Dollar Avg. Inventory (units) Volume 380 300 120 75 60 30 20 12 5 7 6 Value ($/unit) 3.75 4.00 2.50 1.50 1.75 2.25 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,298 % of Dollar Volume 36.39 9.10 3.18 0.70 0.75 0.42 0.55
A busness is aunchng a new product. The aunch wil require a number of related actvties as follows hre (7 weeks) select an advertising agency (2 weeks), plan an advertising campaign wth the agency (4 weeks),products from the manufacturer (13 weeks) select distributors for the product (9 weeks), take initial orders fromoperation (12 weeks), pack enough products for the launch stock (8 weeks), order the launch quantty ofthe distrbutors (3 weeks), dispatch the initial orders to the distrbutors (2 weeks). (a) What is the earest timeconduct the advertsing campaign (10 weeks), design the packaging of the product (4 weeks), set up packinga sales manager (5 weeks), requre the sales manager to recruit saes peope (4 weeks), tran the sales people that the new product can be ntroduced to the market? (b) If the company hre traned salesmen who do notneed further training, coud the product be introduced 7 weeks earler? (c) How long could one delay selectngthe advertising agency? In the example above,…
20. Identifying true or false: I - Just-in-time purchasing is guided solely by the economic order quantity. II - Companies that implement JIT purchasing will switch their suppliers when another supplier offers alower price. III - Just-in-time purchasing describes the flow of goods, services, and information from the initial sourcesof materials and services to the delivery of products to consumers, regardless of whether those activities occur in the same organization or in other organizations Group of answer choices All are false. T, T, F F, F, T All are true T, F, T
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Compute the probability of a stock-out for the…
27) Ali has a restaurant where the customers use a different number of disposable cups each day he is open. Every 30 days, Ali places an order to replenish his cup inventory. It takes 3 days for the order to arrive, at which point it brings the inventory level up to 4000 cups. It costs Ali $30 to have the order processed. Select all statements that apply to Ali's situation: Group of answer choices a) Ali uses a Continuous Inventory System b) d is constant c) Ali uses a Periodic Inventory System d) Ali uses a Fixed-Order-Quantity Inventory System e) Maximum Inventory Level is constant
Q: A hardware company stocks nuts and bolts and orders them from a local supplier once every 2 weeks (10 working days). Lead time is 2 days. The company has determined that the average demand for 1⁄2 inch bolts is 150 per week (5 working days), and it wants to keep a safety stock of 3 days’ supply on hand. An order is to be placed this week, and the stock on hand is 130 bolts.a. What is the target level?b. How many 1⁄2 inch bolts should be ordered this time?
What are the benefits and limitations of comparative scale measurements? Design a ranking order scale that will enable you to determine brand preference between Bud Light, Miller Lite, Coors Light, and Old Milwaukee Light beers.
3(AL Jn 2020, Square-Nine Entrerprise has purchased 250,000 micro-chips for the first four months and 35% more on the remainder as a component in the production of its products. As much as 25% of the purchase is not used but instead stored in the warehouse. Each unit of the final product is sold in the market at a price of $18.99 per unit, and the storage cost is a total of $1.13 per unit. The cost price of the order is $5,500 for each delivery that takes three weeks. Calculate: 1) An annual optimal order quantity. 2) A total of number of orders placed in a year. 3) Time range between orders if the company operates for 49 weeks in a year 4) What are total units for reorder point? 5) Cost of Goods Sold.
2. A manager then obtained 10 lists of items with their following unit cost and gets the peso value in annual basis. By doing the A-B approach you will need to multiply the annual demand for t particular items to its unit costs as follows: Item Number Annual Demand Unit Cost Annual Peso Value 1 3,500 360 2 2,000 70 3 5,400 500 4 2,500 100 5 1,200 70 6 2,000 1,000 7 1,200 210 8 2,000 4,000 9 10,000 10 10 1,500 200 Item Number Annual Peso Classification % of item Value 2/3 % of annual Peso Value