Dave Fletcher, the general manager of North Carolina Engineering Corporation (NCEC), thinks that his firm'sengineering services contracted to highway construction firms are directly related to the volume of highwayconstruction business contracted with companies in his geographic area. He wonders if this is really so, and if it iscan this information help him plan his operations better by forecasting the quantity of his engineering servicesrequired by construction firms in each quarter of the year? The following table presents the sales of his services andtotal amounts of contracts for highway construction over the last 8 quarters:QuarterSales of NCEC Services (in $ thousands)Contracts Released (in $ thousands)1715321017234149197 1759-0-0where y Dependent Variable and x = Independent Variable.D561311202182781116205 223a) Using the given data, the least-squares regression equation for predicting the level of demand of NCEC's servicesis (round your responses to two decimal places):

Answered: Dave Fletcher, the general manager of…

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

The distribution of daily demand for party cakes at a bakery is shown in the following table: Relative Frequency Demand 0.05 10 0.03 22 0.05 37 0.06 45 0.03 53 0.39 61 0.19 88 0.2 111 Determine the optimal number of cakes to make each day if labour and material are estimated to cost $26.985 per unit. Cakes are sold for $38.55 per unit, and leftover cakes at the end of the day are sold next day at half price. O a. 45 O b. 88 Oc. 61 O d. 111 O e. 53
Cotton Island Fashions, a clothing producer, has generated a forecast for the next eightweeks. Demand is expected to be fairly steady, except for periods 3 and 4, which havehigher demands.Month 1 2 3 4 5 6 7 8 TotalForecast 1200 1200 1400 3000 1200 1200 1200 1200 11600The company typically hires seasonal workers to handle the extra workload in periods 3and 4. The cost for hiring and training a seasonal worker is $50 per worker, and thecompany plans to hire two additional workers and train them in period 3, for work in period4, and then lay them off (no cost for layoff). Develop an aggregate plan that uses steadyoutput from regular workers with added output from the two seasonal workers in period 4.The output rate for the seasonal workers is slightly less than that of regular workers, sotheir cost per unit is higher. The cost per unit for regular workers is $4 per unit, while costper unit for the seasonal workers is $5 per unit. Backlog cost is $1 per unit per period.
The following information relates to the performance of a manager in 2020. Benchmark weight Return on the benchmark Actual returnActual Weight Equity Bonds Cash 7.28% 0.6 0.5 6.00% 3.20% 0.90% 3.60% 0.90% 0.2 0.3 0.2 0.2 Details of investments in different sectors of the equity market are as follows: Sector Beginning of month weights S&P 500 Sector return Basic material 1.96 6.30 6.9 Business services 5.80 7.10 7.0 Capital goods 1.91 8.80 4.1 Consumer cyclical 8.47 12.50 8.8 Consumer non-cyclical 40.37 19.40 10.0 Credit sensitive 24.01 20.80 5.0 Energy Technology 13.53 13.20 2.6 3.95 11.90 0.6
Please do not write in column A Problem 6 Given the following forecast and cost information, determine the total cost of a plan that uses regular time production output of 600 units per month, overtime is used when needed up to a maximum of 60 units per month, and subcontracting is used if additional units are needed to meet the forecast. Regular time cost $ 40.00 per unit Overtime cost $ 60.00 per unit subcontracting cost $ 80.00 per unit holding cost $ 10.00 per unit per month Production Inventory Costs Month Forecast Level Production Overtime Subcontracting Total Holding Cost Regular Time Overtime Subcontracting Total Cost 1 563 0 2 608 3 648 4 668 5 666 6 688 Totals
PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 85 full-time equivalent pharmacists (combination of full time and part time) and 175 full-time equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 260 full-time equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management stated that at least 15 new pharmacists must be hired. In addition, PharmaPlus's new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $56 per hour and the average salary for technicians…
How do non-linear system models differ from linear models, and what are the challenges associated with analyzing and controlling them?
How can the Ansoff Matrix be used to analyse the airline industry?
Companies like Microsoft and Apple started selling tablets in place of laptops. Many customers switched their purchases from laptops to Tablets. Most of the functions of laptops were also performed by the tablets. Many laptop producers started losing customers. The competitive force mentioned in this scenario is O a. Rivalry among existing competitors. O b. Bargaining power of the suppliers. O c. Threat of substitutes. O d. Bargaining power of the producers.
Complete the following: Target Based Situation: Produce products within 30 days Objective: Limiting Factors: Target Based Situation: Budgeting of 1 million pesos Objective: Limiting Factors:
Ana Chavarria, front office manager at The Times Hotel, has completed a yield management seminar at Keystone University and is preparing an argument to adopt this concept at The Times Hotel to present to Margaret Chu, general manager. She begins by com- piling a history of room occupancy and ADRs, which she hopes will reveal areas in which yield management could help. She prepares an electronic spreadsheet that lists rooms sold with corresponding room rates and correlates the data to tourism activities in the area. Ana sends an analysis of revenue realized and revenue potential to Ms. Chu for review prior to their discussion. After reviewing the analysis, Ms. Chu concludes, “This is just another scam; the industry is slow to adopt this,” and disregards the entire report. She knows that occupancy percentage, ADR, and RevPAR are all that you need to be efficient today, so why change? Ana passes Ms. Chu in the lobby, and Ms. Chu indicates her distrust of the yield management concept but…
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
Mark Hopper owns Dane Champions, a dog kennel that raises champion Great Danes for showing and breeding. His vision is to be the best-known breeder of Great Danes globally. His strategy is to breed and sell dogs from outstanding lineage from the standpoint of both physical health and good-natured temperaments. Following is information about operations over the last year. Number of breedings Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦.. 10 Number of puppies Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦.. 45 Number of puppies sold…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS