I need sub part 6 and 7 answered please ### Leslie’s Operating Information for the Last Year#### Monthly Data on Jerseys Printed and Operating Costs| **Month** | **Number of Jerseys Printed** | **Operating Cost** ||---------------|-------------------------------|--------------------|| January | 200 | $5,735 || February | 225 | $5,830 || March | 575 | $8,690 || April | 680 | $9,800 || May | 625 | $9,275 || June | 410 | $6,230 || July | 390 | $6,140 || August | 230 | $5,940 || September | 180 | $4,810 || October | 305 | $6,005 || November | 235 | $5,960 || December | 190 | $4,955 |#### Required Calculations3. **High-Low Method for Fixed and Variable Costs:** Calculate the store’s total fixed operating costs and variable operating cost per jersey using the high-low method.4. **High-Low Method for Expected Costs (455 Jerseys):** Calculate the store’s expected operating cost if 455 jerseys are printed, using the high-low method results.5. **Least-Squares Regression Analysis:** Perform a least-squares regression analysis on Leslie’s data to determine the relationship between the number of jerseys printed and operating costs.6. **Regression Output - Linear Equation:** Using the regression output, create a linear equation $ y = a + bx $, where $ y $ is the total operating cost and $ x $ is the number of jerseys printed, for estimating Leslie’s operating costs. Round your answers to 2 decimal places.7. **Least-Squares Regression for Expected Costs (600 Jerseys):** Using the least-squares regression results, calculate the store’s expected operating cost if it prints 600 jerseys.#### Instructions- Enter your answers for each required calculation in the tabs provided below.- Ensure to round your answers appropriately as specified in the instructions.These calculations will assist in understanding cost behaviors and making informed operational decisions at Leslie's store.

5. Perform a least-squares regression analysis on Leslie's data. 6. Using the regression output, create a linear equation (y = a+ bx) for estimating Leslie's operating costs. 7. Using the least-squares regression results, calculate the store's expected operating cost if it prints 600 jerseys.

5. Perform a least-squares regression analysis on Leslie's data. 6. Using the regression output, create a linear equation (y = a+ bx) for estimating Leslie's operating costs. 7. Using the least-squares regression results, calculate the store's expected operating cost if it prints 600 jerseys.

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

What are the advantages and disadvantages of using a manual guest check system to control revenue in nonautomated beverage operations?
Define IT services and distinguish between infrastructure services and application services in the context of IT service management.
DEMU 2103, va assignmen QUESTION 3 Metropolitan General Hospital is a city-owned and operated public hospital. Its emergency. room is the largest and most prominent in the city. Approximately 70% of emergency cases in the city come or are sent to Metro General's emergency room. As a result, the emergency room is often crowded and the staff is overworked, causing concern among hospital administrators and city officials about the quality of service and health care the emergency room is able to provide. One of the key quality attributes administrators focus on is patient waiting time that is, the time between when a patient checks in and registers and when the patient first sees an appropriate medical staff member. Hospital administration wants to monitor patient waiting time using statistical process control charts. At different times of the day over a period of several days, patient waiting times were recorded at random with the following results: Sample 1 2 3 4 5 6 7 8 9 10 1 27 22 16…
Please do not give solution in image format thanku
Employee Wanda Trews was working in the manufacturing facility at Coves Industrial. The employees of Coves Industrial manufacture diesel engines for the airline industry. Wanda works on Line 3 in the facility and from time-to-time works on Line 7 as a relief worker to cover employee breaks. Wanda was asked to leave Line 3 and provide break coverage on Line 7 for 2 hours on September 19, 2021. Earlier that day, there had been a mechanical difficulty with the stamping machine on Line 7. The maintenance team was able to get the machine working again but they call the manufacturer of the stamping machine as the machine doesn’t sound right and it clearly needs further maintenance. When Wanda arrived at Line 7 to provide break coverage, she checks in with Line 7 supervisor Raoul Steves. Raoul advises that Wanda needs to manufacture 200 components during her 2 hours on Line 7 and to let him know if she needs any help. Raoul does not mention the earlier mechanical issue with…
An employee arrives to work at 8:00 AM and is scheduled to conduct blood specimen testing. The equipment, however, is not working and cannot be repaired until at least 9:30 AM. In the interim, the supervisor instructs the employee to stay in the department until the repair specialist arrives. While waiting the employee does some studying for a course he is taking at the local community college.Is the employer obligated to pay the employee for the time the employee studies?
Employee Wanda Trews was working in the manufacturing facility at Coves Industrial. The employees of Coves Industrial manufacture diesel engines for the airline industry. Wanda works on Line 3 in the facility and from time-to-time works on Line 7 as a relief worker to cover employee breaks. Wanda was asked to leave Line 3 and provide break coverage on Line 7 for 2 hours on September 19, 2021. Earlier that day, there had been a mechanical difficulty with the stamping machine on Line 7. The maintenance team was able to get the machine working again but they call the manufacturer of the stamping machine as the machine doesn’t sound right and it clearly needs further maintenance. When Wanda arrived at Line 7 to provide break coverage, she checks in with Line 7 supervisor Raoul Steves. Raoul advises that Wanda needs to manufacture 200 components during her 2 hours on Line 7 and to let him know if she needs any help. Raoul does not mention the earlier mechanical issue with…
b. What is the longest wait time experienced by a customer?
Five jobs are waiting for processing through two work centers. Their processing time (in minutes) at each work center is contained in the table below. Each job requires work center Alpha before work center Beta. According to Johnson's rule, which job should be scheduled first in the sequence? O A. V OB. U O C. R OD. S O E. T Job R S T Alpha 20 23 50 26 55 Beta 34 35 20 26 75
In addition to the food ordering system, Bob and Thelma asked you to develop an employee management system as they have had the challenging task to administer and handle information for all the workers of Hoosier Burger. To have a reliable and up-to-date source of information concerning workers, they need a reliable, fast, readily accessible system from which they can refer and update employee information. When a new worker starts, the worker’s basic information needs to be entered into the new information system. There are different types of workers: cashier, delivery driver, cook, inventory worker. When a worker’s status changes, such change should be updated in the system. A change of workers status could be promotion, dismissal, reclassification, marital status, employment, transfer, 5termination etc. The employee management system should also act as a source of information for payroll. They need to maintain the wage rate of each employee and work hours to prepare their bi-weekly…