Please provide excel calculation as well 6-40 A photocopy machine company produces three typesof laser printers-the Print Jet, the Print Desk, andthe Print Pro the sale of which earn profits of $60,$90, and $73, respectively. The Print Jet requires2.9 hours of assembly time and 1.4 hours of testingtime. The Print Desk requires 3.7 hours of assem-bly time and 2.1 hours of testing time. The Print Prorequires 3 hours of assembly time and 1.7 hours oftesting time. The company wants to ensure that PrintDesk constitutes at least 15% of the total productionand Print Jet and Print Desk together constitute atleast 40% of the total production. There are 3,600hours of assembly time and 2,000 hours of testingtime available for the month. What combination ofprinters should be produced to maximize profits?

Profit$60$90$73Assembly hrs.2.93.73Testing hrs.1.42.11.7Constraints 1-0.150.85-0.15Constraints…

A photocopy machine company produces three types of laser printers—the Print Jet, the Print Desk, and the Print Pro-the sale of which earn profits of $60, $90, and $73, respectively. The Print Jet requires 2.9 hours of assembly time and 1.4 hours of testing time. The Print Desk requires 3.7 hours of assem-

A photocopy machine company produces three types of laser printers—the Print Jet, the Print Desk, and the Print Pro-the sale of which earn profits of $60, $90, and $73, respectively. The Print Jet requires 2.9 hours of assembly time and 1.4 hours of testing time. The Print Desk requires 3.7 hours of assem-

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

On August, a light business bought $3600 worth of lamps. At the beginning of September, the store had $1400 in lights on hand, and by the end of September, it projected to have $1600 in lamps on hand to meet some of the forecasted October sales. And what's the August planned cost of goods sold?
a Tax Revenue ($) Refer to the above Laffer Curve diagram. Going into the sluggish U.S. economy of the early 1980s, economist Arthur Laffer and President Ronald Reagan maintained that that the economy was located at O tax rate d. O some level above tax rate b. O some level below tax rate b. O tax rate b. of Tax Rate (%)
please help me with Question 3 thanks! Demand forecasts for 2021 are as follows: Month Demand Jan 140,000 Feb 78,900 Mar 85,800 Apr 89,100 May 123,600 Jun 136,350 Jul 120,450 Aug 106,950 Sep 121,950 Oct 135,750 Nov 87,000 Dec 93,300 Each worker can produce 900 products per month and is paid $1500 per month. Assume that at the end of last year, the company has 100 employees working on the production line. Hiring and layoff (firing) decisions are made at the beginning of each month, and associated costs are charged at that time. It costs the company $400 to hire and $800 to lay off a worker. The company incurs holding cost for the amount of ending inventory in each month, and incurs backorder cost at the end of each month for any unfilled orders. The company incurs $2 per month for holding one unit in inventory and $4 per unit backorder. 1 Prepare a level aggregate plan. Under this level aggregate plan, how…
UPVOTE WILL BE GIVEN! PLEASE ANSWER IN TYPEWRITTEN. ANSWER WHAT IS BEING ASKED.
Cash flow; classify the following in the perspective of a business/individual owner. cash in flow cash out flow 1. permits 2.retail sales 3.rents 4.business loan 5.fare 6.water bill 7.salary 8.taxes 9.own professional fee 10.electric bill
John Ozment, director of special projects and analysis for Ozment’s Corporation, is responsible for preparing corporate financial analyses and monthly statements and reviewing and presenting the economic impacts of proposed strategies to upper management. Data for such financial analyses are obtained from operations and financial databases through direct queries of Ozment’s department staff. Reports and charts for presentations are then prepared by hand and typed. Multiple copies are prepared and distributed to various users. The pressure on Ozment’s group has intensified as demand for more and more current information increases. A solution to this reporting problem must be found.The systems department wants to develop a proprietary software package to produce the reports automatically. The project would require the company to make a considerable programming investment. Ozment is concerned about the accuracy, completeness, and currency of data isautomatically produced reports. He has…
Year Month Actual Orders/Demands 2020 Apr 120 May 90 Jun 100 Jul 75 Aug 110 Sep 50 Oct 75 Nov 130 Dec 110 2021 Jan 90 Feb
Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70
This document is used primarily by owners/investors to verify the financial health of the organization. Uniform System of Accounts Balance Sheet Production Control Sheet Income Statement
Please do not give solution in image format thanku In 2018, the government of Ghana launched operation one district one factory (IDIE). Based on IDIF, Ekumfi Pineapple Factory Co. Ltd (EPF) was launched. In 2019 the management of ERF started production with 100 workers per shift, each of the three shifts working 8 hours per day. Every working day the payroll cost was GHIC 20,000 and overhead expenses amounted to GHC 5000 and material cost GHC 4000. At the end of the first year, the company produced 1,000,000 boxes of pineapple juice. During the second year, EPF acquired a loan from Exim Bank to purchase a new plant. After the introduction of the new plant, the management reduced the size of its workers per shift to 80, each working 8 hours per day, with the payroll cost reducing to GHC 18,000 and overhead expenses also reducing to GHC 4000 and material cost rising to GHC 6000. Production rose to 1,200,000 boxes. Regard yourself as the Operations Manager of EPF: a) What are the…
Which of the following problems are not among those hidden when inventory levels are excessively high? A) Inadequate worker motivation B) Engineering design redundancies C) Scrap D) Productive equipment downtime E) Paperwork backlogs
2-19. EXCEL APPLICATION: IT Benchmarks Jay's Bikes is a family-owned and operated business that stocks a wide range of bikes designed to fit the needs of professional riders, your child's first bike, and everything in between. The business has 12 full-time employees. Download the Excel file Ch02Ex01 (Figure 2.21) to calculate average IT spending so that it can be compared with the retail industry average. Recall that average IT spending in the retail industry is about 2 percent of revenue. How do Jay's IT expenditures compare with the industry average? How much would Jay need to change spending in order to match the retail industry average? Figure 2.21 Jay's Bikes revenue and IT expenditures. A 1 2 3 34 Revenue B Apparel & shoes Bike accessories New bikes Used bikes Bike repairs 5 6 7 IT Expenditures Hardware 8 9 10 11 12 13 с $ 1,250,000 $ 550,000 $ 2,650,000 $ $ $ 15,000 18,000 4,500 4,500 5,000 5,000 $ 1,200 sssssssssss Software updates Software licenses Software support Employee…