Following the format of the spreadsheet in Figure 2, develop a spreadsheet to forecast Fitter's sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Following the format of the spreadsheet in Figure 2, develop a spreadsheet to forecast Fitter's sales for July through December. Calculate the base projection using the previous year's values (shown in Figure 1), and factor in the 3 percent estimated growth rate. Assume that the special marketing promotion last year resulted in an increase in sales of 200 cases for July and that a special marketing promotion this year will result in an increase in sales for July of 400 cases. Sales volume July August September October November December Previous year 6702 6327 6215 6007 5954 5813 Source line: Course Technology /Cengage Learning. FIGURE 1 Fitter's sales for last year, July through December Sales forecasting Previous year (cases) January February March April May June 5734 5823 5884 6134 6587 6735 Promotion sales (cases) Previous year base (cases) Growth 300 300 5734 5823 5884 6134 6287 6435 3.0 % 172 175 177 184 189 193 Base projection (cases) Promotion (cases) Sales forecast (cases) 5906 5998 6061 6318 6476 6628 500 5906 5998 6061 6318 6476 7128 Source line: Course Technology /Cengage Learning. FIGURE 2 Fitter's sales forecast for January through June Following the format of the spreadsheet in Figure 2, develop a spreadsheet to forecast Fitter's sales for July through December. Calculate the base projection using the previous year's values (shown in Figure 1), and factor in the 3 percent estimated growth rate. Assume that the special marketing promotion last year resulted in an increase in sales of 200 cases for July and that a special marketing promotion this year will result in an increase in sales for July of 400 cases. Sales volume July August September October November December Previous year 6702 6327 6215 6007 5954 5813 Source line: Course Technology /Cengage Learning. FIGURE 1 Fitter's sales for last year, July through December Sales forecasting Previous year (cases) January February March April May June 5734 5823 5884 6134 6587 6735 Promotion sales (cases) Previous year base (cases) Growth 300 300 5734 5823 5884 6134 6287 6435 3.0 % 172 175 177 184 189 193 Base projection (cases) Promotion (cases) Sales forecast (cases) 5906 5998 6061 6318 6476 6628 500 5906 5998 6061 6318 6476 7128 Source line: Course Technology /Cengage Learning. FIGURE 2 Fitter's sales forecast for January through June
Expert Answer:
Answer rating: 100% (QA)
Company F has not formally developed its sales forecasting and production patterns Adopting the inst... View the full answer
Related Book For
Introduction to Operations and Supply Chain Management
ISBN: 978-0132747325
3rd edition
Authors: Cecil B. Bozarth, Robert B. Handfield
Posted Date:
Students also viewed these general management questions
-
Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? PERIOD DEMAND 1............ 221 2............ 247...
-
Fitters current sales order accounting processes involves recording sales in each division and then periodically sending certain sales data to Accounting for invoicing and financial reporting....
-
Susan plans for her children and children's children to inherit a perpetual annual cash amount entitlement starting at some point in the future. Susan estimates that her investment will be worth one...
-
Which of the environmental policy options discussed in this and previous chapters would you recommend if a hypothetical society were facing the following environmental problems? In each case, briefly...
-
Studies that compare treatments for chronic medical conditions such as headaches can use the same subjects for each treatment. This type of study is commonly referred to as a crossover design. With a...
-
Kellye, Becky, and Emily formed Whoop! Shotz Corporation with the following contributions: Kellye $50,000 cash Becky $50,000 cash Emily Legal services Each was given a...
-
What is an open-end mutual fund?
-
For the following test marketing project at week 6: a. Ignore the far right % Complete column and using the 5050 percent completion rule for PV and EV, calculate the cost, schedule, and time...
-
Sometime ago a financial institution entered a swap where it agreed to receive 3.8% per annum with semi-annual compounding and pay LIBOR every six months on $100 million. The swap has exactly 13...
-
The Division of Housing and Food Services at Northeastern State University (NSU) has recently implemented a "debit card" system that allows any NSU student to make purchases on campus using their...
-
Estimate the relevant business risk associated with an investment in the Monticello mill and the corrugated box plants, using the comparison company ("pure play") approach. Describe your criteria for...
-
A machine (a Section 1231 asset that is also a Section 1245 asset) was acquired on February 5, Year 1 for $180,000. It is five-year MACRS property and cost recovery (accumulated depreciation) totals...
-
Comparing LIFO and FIFO, which cost flow assumption will give you higher COGS? Higher Inventory? Why?
-
The Elsewhere Gift Shop sells items it imports from Europe. Its inventory includes clocks, hand-made linens, ornaments, and jewelry. Elsewhere sells one of the German nutcrackers it carries for $45 ....
-
What are some present and potential threats in the Armco, Inc: Midwestern Steel Division?
-
I have most of the code here but I keep getting errors so could someone please run it and fix the problems, you can make changes to it where you see fit but make sure you comment where the changes...
-
On April 29, 2015, Auk Corporation acquires 100% of the outstanding stock of Amazon Corporation (E & P of $750,000) for $1.2 million. Amazon has assets with a fair market value of $1.4 million (basis...
-
Why is it important for rms to have a logistics strategy? What could happen if a rm did not logically link its logistics decisions to the needs of its customers?
-
Is it enough to just write down the business strategy of a rm? Why or why not? Conversely, what are the limitations of not writing down the strategy but rather depending on the rm's actions to dene...
-
Dr. Mike Douvas is opening a new sports clinic and is wondering how to arrange the six different departments of the clinic: 1. Waiting; 2. Reception; 3. Records and staff lounge; 4. Examination; 5....
-
Lessory Corporation, a manufacturer of equipment, enters into a lease of specialized equipment with LesseeX Corp. Title to the asset remains with Lessory Corp upon lease expiration. LesseeX Corp does...
-
Using the information from Exercise 17-74, complete the following requirements from the lessor's perspective. Assume that lessor classifies the equipment as inventory prior to the lease arrangement....
-
On January 1, 2020, Frozen Yogart Inc. signed a 10 -year lease for its retail outlet. The lease payments, paid semiannually, are based upon semiannual sales and will equal \(5 \%\) of sales with a...
Study smarter with the SolutionInn App