Lovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store man- ager estimates a probable six-week lag between fertilizer sales and mower sales. The pertinent data are: Period 1 234567 2 3 4 5 7 Fertilizer Sales (tons) 1.6 1.3 1.8 2.0 2.2 1.6 1.5 Number of Mowers Sold (six-week lag) 10 8 11 12 12 9 8 Period 8 9 10 11 12 13 14 Fertilizer Sales (tons) 1.3 1.7 1.2 1.9 1.4 1.7 1.6 Number of Mowers Sold (six-week lag) 7 10 6 11 8 10 9 a. Determine the correlation between the two variables. Does it appear that a relationship between these variables will yield good predictions? Explain. b. Obtain a linear regression line for the data. c. Predict expected lawn mower sales for the first week in August, given fertilizer sales six weeks earlier of 2 tons.

Lovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store man- ager estimates a probable six-week lag between fertilizer sales and mower sales. The pertinent data are: Period 1 234567 2 3 4 5 7 Fertilizer Sales (tons) 1.6 1.3 1.8 2.0 2.2 1.6 1.5 Number of Mowers Sold (six-week lag) 10 8 11 12 12 9 8 Period 8 9 10 11 12 13 14 Fertilizer Sales (tons) 1.3 1.7 1.2 1.9 1.4 1.7 1.6 Number of Mowers Sold (six-week lag) 7 10 6 11 8 10 9 a. Determine the correlation between the two variables. Does it appear that a relationship between these variables will yield good predictions? Explain. b. Obtain a linear regression line for the data. c. Predict expected lawn mower sales for the first week in August, given fertilizer sales six weeks earlier of 2 tons.

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

Related questions

Q: Question 4) APP Linear Programming Given the following information: Quarter Demand Regular Prod.…

A: Suppose x1, x2, and x3 are the units produced in 1stquarter, 2ndquarter, and 3rdquarter…

Q: Table below is a time-phased net requirements for Widgets over the next six weeks. Week 1 5…

A: Find the Calculation methods below: Total cost (Period 1) = Setup costTotal cost (Period 2) = Setup…

Q: Question 2. Manatee Splash is going from stregth to strength. Production is at 22,500/day. Daily…

A: Note:Dear student you have mentioned only question 2. So i have solved ‘2’ onlyCAPACITY…

Q: The weekly requirements for a particular product is shown below: Week 1 3 4 5 7 8. 9. 10 Demand 20…

A: Given that: The number of weeks and demand: Week Demand 1 20 2 50 3 10 4 50 5 50 6…

Q: QUESTION 1 A master production schedule shows the following information MPS Week Week Week Week…

A: Find the Given details below: Weeks 1 2 3 4 Forecasted Demand 1000 1200 1300 1200 Actual…

Q: QUESTION ONE The diagram below shows demand and supply curves for good K; where Do and So are the…

A: From the Supply demand curve: Initially, the equilibrium happens when the Price = 2 and the demand…

Q: Penny Farthing Penny Farthing, a leading manufacture of full metal and coil wire zippers, has been…

Q: Question attahed in image

A: Note: - As we can answer only up to three subparts we will answer the first three(a, b, and c)…

Q: APP Trial and Error Given the following information: Quarter Demand 2…

A: The utilization of a level procedure implies that an organization will deliver at a consistent rate…

Q: Compute for the Cost of Goods Sold using the following:

A: Cost of goods sold is basically the cost that is incurred to produce the goods which are sold.

Q: 1. Explain and give examples of the following three types of Stay Controls: a) Minimum stay…

A: Note: “Since you have asked multiple questions, we will solve the first question for you. If you…

Q: Problem 1 The following information applies to the City View Restaurant. May 1 Food inventory value:…

A: Inventory control is also described as the control of stock and is a means of managing of inventory…

Q: 6. The University cafeteria is offering meal plans for their students on a tight budget. They can…

A: Find the given details below: Given details: Plan Monthly cost Extra cost Gold $…

Q: 2. A city is holding an annual marathon event and wants to produce t-shits. Alfonso was able to…

A: sales volume =min(volume prepared, demand)egrow1, column 2sales volume = min(1000,2000)=1000 demand…

Q: wer for 3.2, 4.1 & 4.2 only This is for knowledge purposes

A: Ques 3Fixed cost = 20000Variables cost = 0.25Selling price = 0.50 Ques 4For outsourced option:Fixed…

Q: Aceron Bhd produces three products A, B and C. The unit cost and selling prices are as shown below:…

Q: QUESTION 11 In a periodic review inventory system, how many units are ordered? OA. Target inventory…

A: As per our guidelines, we are supposed to answer only one question if multiple questions are asked.

Q: Montreal Hardware Co. is making a make-or-buy decision. The market feedback shows that the optimal…

A: A decision tree refers to the tree that supports tools or equipment that utilizes a tree-like…

Q: General Admission (includes admission to over 35 galleries and non-surcharged exhibitions) FREE…

A: The Museum of Illusions in New Delhi, India, is a one-of-a-kind and interactive museum that tests…

Q: a. If carrying costs are $2 per year for each stone, find the order quantity that will minimize…

A: EOQ stands for economic order quantity. It is a company's optimal order quantity that undervalues…

Q: Problem 11-14 (Algo) Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella…

A: Given data: Average weekly Demand (d) =160 pounds/week Standard deviation = 26 pounds Inventory (I)…

Q: 1. In deciding on where to locate their next grocery store, Publix narrowed it down to 3 locations…

A: Find the given details below: Given details: Criteria Weight Locations St. Augustine JAX…

Question

please answer ASAP . Q2

Subject : production and operation management

Lovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store man-
ager estimates a probable six-week lag between fertilizer sales and mower sales. The pertinent data are:
Period
1
2
3
4
5
6
7
Fertilizer
Sales
(tons)
1.6
1.3
1.8
2.0
2.2
1.6
1.5
Number of
Mowers Sold
(six-week lag)
10
8
11
12
12
9
8
Period
8
9
10
11
12
13
14
Fertilizer
Sales
(tons)
1.3
1.7
1.2
1.9
1.4
1.7
1.6
Number of
Mowers Sold
(six-week lag)
7
10
6
11
8
10
9
a. Determine the correlation between the two variables. Does it appear that a relationship between
these variables will yield good predictions? Explain.
b. Obtain a linear regression line for the data.
c. Predict expected lawn mower sales for the first week in August, given fertilizer sales six weeks
earlier of 2 tons.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Q2) 3. What is long range plan?
Required information Lyndia Company is a merchandiser that sells a total of 15 products to its customers. The company provided the following information from last year: Selling Price Variable Cost Product 1 Unit Sales per Unit per Unit 9,000 $ 29 $12.95 2 16,500 $ 99 $68.55 3 6,000 $ 85 $42.50 4 19,500 $109 $85.00 5 4,500 $ 19 $ 6.35 6 27,000 $119 7 3,000 $ 39 $92.00 $14.30 8 7,500 $ 79 $33.18 9 9,000 $ 69 $30.36 10 15,000 $.95 $77.60 11 10,500 $ 59 $25.40 12 1,500 $ 65 $29.00 222 13 3,000 $ 44 $12.40 141 6,000 $ 49 $13.48 15 12,000 150,000 $ 89 $61.83 Last year, Lyndia's total fixed expenses and net operating income were $3,000,000 and $1,223,070, respectively. The company would like your assistance in developing some financial projections for this year.
Question 3: Complete the following table. Lead time for the part is two weeks, and the order quantity is 30. What action should be taken? Week Gross Requirements Projected Available Net Requirements Planned Order Receipt Planned Order Release 30 1 10 2 15 3 10 4 20 5 15 6 25 7 10
QUESTION 2 CLO 4: Explain the role of risk management in portfolio management Evaluate risk measurement techniques (20 marks) a) with The average returns, standard deviations and betas for three funds are given below along data for the S&P 500 index. The risk free return during the sample period is 6%. The average returns, standard deviations and betas for three funds are given below along with data for the S&P 500 index. The risk free return during the sample period is 6%. a) The average returns, standard deviations and betas for three funds are given below along with data for the S&P 500 index. The risk free return during the sample period is 6%. Fund Avg Return St Dev Beta A 13.6% 40% 11 B 13.1% 25% 10 12.4% 30% 13 S&P 500 120% 15% 10 i) ii) You wish to evaluate the three mutual funds using the Sharpe measure for performance evaluation. The fund with the highest Sharpe measure of performance is (Show your workings) Calculate and rank the funds using Jensen's alpha, Treynor measure,…
Q4 Costs: LayoffHiringInventory Totals: 246 246 30,000 Costs: $246,000 $492,000 $30,000 Cost of plan:$768,000 Planning values Starting inventory: 2,500 Starting and ending workforce: 200 Hours worked per month per hour: 360 Hours per unit: 40 Hiring cost per worker: $2,000 Layoff cost per worker: $1,000 Monthly per-unit holding cost: $1 Forecasted sales:Month Forecasted salesMarch 1,827April 1,620May 1,440June 1,179July 1,611August 2,115September 2,637October 2,502November 3,150December 3,231January 2,826February 2,331
Cachora Dynamics Corp (CDC) has designed a new integrated circuit that will allow it to enter, if it wishes, the microcomputer field. Otherwise, it can sell its rights for $15 million. If it chooses to build computers, the profitability of this project depends on the company's ability to market them during the first year. Two levels of sales are foreseen as two possible outcomes: selling 10,000 computers in case of low demand, but if it is successful it can sell up to 100,000 units (high demand). The cost of installing the production line is $6 million. The difference between the selling price and the variable cost of each computer is $600. a) Develop a formulation for decision analysis and use the non-probabilistic decision rules: Maximin and Minimax. b) Assume that the probability of high demand (p) is 50% and for low demand (1 - p) is 50%, apply the probabilistic criteria: Maximum expected value, Minimum loss of opportunity. c) Determine the VEIP. d) Carry out a sensitivity…
Question 9 What was the static budget amount for direct materials?
Business Name: CV Water Refill Location: 3rd Street Chula Vista, CA 91911 Financial Management: a. Accounting (How will you manage your business accounting?): b. Professional Resources (List all to be used): c. Credit and Financing (List resources for financing your business venture): d. Billable Rate/Break-Even Sales
Costs Previous quarter's output Beginning inventory Stockout cost for backorders Inventory holding cost 1,500 units O units $50 per unit $10 per unit for every unit held at the end of the quarter $40 per unit $80 per unit $30 per unit $15 extra per unit Not available Hiring workers Layoff workers Unit cost Overtime Subcontracting a) Use Chase Demand Strategy b) Use Level Production Strategy with Backordering
QUESTION 45 Suppose that a social venture scales its activities in several geographic locations by establishing units that are tightly controlled by headquarters. This would be an example of ____. Affiliation. Capacity building. Branching. Social franchising.
H1.
QUESTION 1 AJ Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand 1 1300 2 1400 3 1500 4 1300 Previous quarter's output = 1,500units Beginning inventory = 200units Stockout costs = $50 per unit Inventory holding cost = $10 per unit at end of quarter Hiring workers = $4 per unit Firing workers = $8 per unit Unit cost = $30 per unit Overtime = $10 extra per unit a) Which of the following production plans is better: Plan A - chase demand by hiring and firing: or plan B - product at a constant rate of 1200 and obtain remainder from overtime? b) Explain the differences between repair and preventive maintenance? c) Explain the implications of each approach when developing an asset maintenance strategy? d) Explain the benfits and challenges associated with the implementation of an MRP system?