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...
-
If 10 percent of the balls in a certain box are red, and if 20 balls are selected from the box at random, with replacement, what is the probability that more than three red balls will be obtained?
-
Business liability insurance can only be issued to organizations and not individuals. A. True B. False
-
The journal of Bell Technology Solutions, Inc., includes the following entries for August, 2010: Requirements 1. Describe each transaction. 2. Set up T-accounts using the following account numbers:...
-
Discuss ways that employers might seek to restrain the salary budget.
-
Consider that you are based in a developed country market and currently considering to expand to an emerging market. Which emerging market are you going to choose? What are the most important...
-
Beth R. Jordan lives at 2322 Skyview Road, Mesa, AZ 85201. She is a tax accountant with Mesa Manufacturing Company, 1203 Western Avenue, Mesa, AZ 85201 (employer identification number 11-1111111)....
-
Write your solutions to these problems neatly on a separate sheet of paper. Make sure your name is on each page and that all pages are stapled together. Betty and Stella are in business together...
-
Why is intercultural literacy needed in today's world? How can the definitions of communication and culture be used to foster this literacy? How is the language used to describe a culture, such as...
-
1 Simplify. 3-10x+25x x3-5x2
-
For this assignment, you will be demonstrating that you know (1) how to read the rhetorical situation of applying for a position, and (2) how to write to that situation by presenting yourself...
-
City of Johannesburg mayor Geoff Makhubo says the city will offer significant debt write-offs to qualifying ratepayers through its debt rehabilitation programme. In his state of the city address on...
-
Batibot, a resident citizen earned the ff incomes: Questions: 1. Income derived from sources WITHIN the Philippines 2. Income derived from sources OUTSIDE the Philippines 3. The TOTAL CAPITAL GAINS...
-
Create an especial environment, using pipenv to run your code. Catch any client errors, checkout this link https://boto3.amazonaws.com/v1/documentation/api/latest/guide/error-handling.html to learn...
-
Chao, Louis, and Mari, unrelated individuals, own all of the shares of Cerise Corporation. All three shareholders have been active in the management of Cerise since its inception. In the current...
-
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....
-
On 1 January 2024, a company receives gross debenture interest of 1,600 from another UK company and pays net debenture interest of 8,640 to individuals. Explain the corporation tax treatment of each...
-
A company's accounts for the 17 months to 30 June 2023 include: The debentures were acquired (not for trade purposes) on 1 May 2022. Interest is payable half-yearly on 30 April and 31 October. Show...
-
Distinguish between P-time and M-time.
Study smarter with the SolutionInn App