Question

In: Operations Management

Sara’s Ice Cream Shop is closed for six months out of the year but has had...

Sara’s Ice Cream Shop is closed for six months out of the year but has had the monthly sales amounts listed below for the last four years.

Year: 2017 2018 2019 2020
May $ 436,033 $ 928,871 $ 535,489 $ 851,191
June 743,438 1,084,328 597,962 741,114
July 1,450,963 1,250,431 1,564,817 1,580,619
August 1,429,245 1,795,341 1,851,460 1,590,258
September 1,179,072 1,023,971 683,804 724,065
October 370,097 466,349 484,744 653,776

Asssuming that there is both seasonality and a trend, estimate monthly sales for each month of the coming year.

2021
MAY
JUNE
JULY
AUGUST
SEPTEMBER
OCTOBER

Solutions

Expert Solution

Monthly Sales will be as follows:

2021 May 698587
June 804999
July 1488059
August 1698693
September 921247
October 504484

Fianl Outcome will be as follows: Follow Step by Step

STEP 1- Finding Intercept (Follow the excel formula)

STEP 2- Finding Slope (Follow the excel formula)

STEP- 3 Finding LT Forecast (Follow the excel formula) Drag till the last i.e. 2021 October

STEP-4 Finding Seasonality Index (Follow the excel formula)

STEP 5 Finding Seasonal Forecast with Trend (Follow the excel formula)  Drag till the last i.e. 2021 October


Related Solutions

An ice-cream shop serves 5 flavors ice-cream to its customers. The shop has seating capacity for...
An ice-cream shop serves 5 flavors ice-cream to its customers. The shop has seating capacity for 6 people. One fine Saturday morning, as the shop opens, 4 kids enter the shop for ice-cream. Please provide expanded formulas or expressions to answer following questions. You need not solve the final arithmetic. 1. What are the different ways in which the 4 kids can sit? 2. What are the different types of orders possible, if each kid orders exactly one serving of...
An ice cream shop sells five-scoop ice cream cones, allowing customers to pick which flavors they...
An ice cream shop sells five-scoop ice cream cones, allowing customers to pick which flavors they want stacked on their cone. The shop has the following ice cream flavors available: chocolate, vanilla, strawberry, mint & chocolate chip, rocky road, cookies & cream, cookie dough, cotton candy, butter pecan, birthday cake, and cherry. Note that customers can order a five-scoop cone with multiple scoops of the same flavor. a) How many five-scoop cones are possible if order of the ice cream...
An ice cream store sells a pint of ice cream for $4.00 each. The shop incurs a monthly fixed cost of $2,000
An ice cream store sells a pint of ice cream for $4.00 each. The shop incurs a monthly fixed cost of $2,000 which includes salaries and rental. The variable cost per pint of ice cream is $1.50. The company is currently selling 600 pints per month.A. How many pints per month does the store need to sell to break-even?B. Using Goal Seek what is the new selling price per pint to achieve a profit of $10,000, if the company continues...
Robert has a passion for making ice cream. Assume that ice cream parlors have a market...
Robert has a passion for making ice cream. Assume that ice cream parlors have a market structure of monopolistic competition. Between the local Amy's, Cold Stone Creamery, Marble Slab, Ben & Jerry's, and Baskin Robbins, he has an uphill battle to break into the local ice cream market. Determine which suggestions below might help Robert differentiate his ice cream shop, JubJub's, so that he can garner some market power. If a suggestions will not help Robert differentiate his product, leave it...
There are two ice cream shops, A and B, in a touristic town. Each shop needs...
There are two ice cream shops, A and B, in a touristic town. Each shop needs to individually choose the price it charges for a scoop of ice cream, which can be either $2, $4 or $5. Each firm wants to maximize their total revenue from customers via an appropriate choice of price. It is expected that − 8,000 scoops of ice cream are purchased by tourists, who are split evenly between the two shops regardless of the prices charged...
Karen is considering opening an ice cream shop. For each of the following costs associated with...
Karen is considering opening an ice cream shop. For each of the following costs associated with her business, explain whether the cost is fixed or variable. $25,000 to lease a building for the shop for one year $0.12 per wrapper each on ice cream cone $2,000 for a year of commercial liability insurance $1.00 of food ingredients for every cone Assume that each cone includes food ingredients and one wrapper. If Karen sells 15,000 ice cream cones in a year...
Danielle and William are visiting an ice cream shop where they will randomly choose one of...
Danielle and William are visiting an ice cream shop where they will randomly choose one of the following five regular and premium flavors. Flavors Price Vanilla Bean $2.00 Chocolate Mint $3.00 Pralines and Cream $4.00 Strawberry Shortcake $5.00 Fudge Brownie Caramel Cheesecake Deluxe $6.00 Define the population as the five services and a sample of size two as the flavor that Danielle chooses and the service that William chooses. a. Identify the frequency distribution for the population b. Identify the...
Kilo-cone is an ice-cream store that sells 1kg ice cream cones, and has the following information:...
Kilo-cone is an ice-cream store that sells 1kg ice cream cones, and has the following information: Estimated monthly Sales (in cones) January to March:       45,000 per month April to September:   70,000 per month October to December: 20,000 per month Ice cream cones sell for $1 each from January 1st to March 31st, and $3 each during the rest of the year. Half of the sales are paid in cash, and the other half is on account. 90% of the sales...
. Suppose each ice cream truck has a marginal cost of $1.50 per ice cream cone...
. Suppose each ice cream truck has a marginal cost of $1.50 per ice cream cone sold and no fixed cost. Suppose the maximum number of ice cream cones sold by any one truck in a day is 100. If the price of an ice cream cone is $2, how many ice cream cones does each truck want to sell? If the industry is perfectly competitive will the price remain at $2 for an ice cream cone? If not, what...
Ice Cream Sandwich Co. expects EBIT of $300,000 every year forever. Ice Cream Sandwich Co. currently...
Ice Cream Sandwich Co. expects EBIT of $300,000 every year forever. Ice Cream Sandwich Co. currently has no debt and its cost of equity is 20%. The firm can borrow at 5%. The corporate tax rate is 33%. The value of the firm is 1005000. Questions: a. what will be the value of the firm if Ice Cream Sandwich Co. borrows $280,000 of permanent debt and uses the proceeds to buy back stock? b. how can Ice Cream Sandwich Co....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT