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?
Globe Industries is a multinational tech company specializing in e-commerce, cloud computing and artificial intelligence. GLOBE INDUSTRIES has an online shopping website/app where persons globally can purchase a variety of new and used goods, including computers, vehicles, music and books. Consumers are not using Globe Industries' e-commerce website/app because it lacks certain functions or features that make their online shopping experience easier. Issue The issue of customer retention has been the topic of discussion among the management team for months at Globe Industries. They have noted several complaints and concerns regarding the predicaments that the company is experiencing, which has negatively affected the company’s profits. The number one complaint noted was; the outdated approach to the company’s operations. This problem is stemming from the lack of access to information by its users from their own personal accounts. It was noted that in order for a transaction to be…
What are the duties and responsibilities of a FLIGHT ATTENDANT?
Define IT services and distinguish between infrastructure services and application services in the context of IT service management.
How do standard circular flow and expanded circular flow differ?
To keep track of the queue and meet deadlines, two things are required: meticulous scheduling and planning.
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?