Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. Janice Bray owns the Little Sister's Bakeshop and Coffee House. She would like to make a daily forecast of her July 1 through July

image text in transcribed
4. Janice Bray owns the Little Sister's Bakeshop and Coffee House. She would like to make a daily forecast of her July 1 through July 7 sales based on her 4-week rolling average of prior daily sales. To be conservative, Janice wants to forecast each day's sales in the first week of July at 98 percent of each day's previous 4-week rolling sales average. Using her June 3 through June 30 daily sales, help Janice complete the 4-Week Rolling Average/Forecast worksheet she has begun to prepare, rounding each day in July's forecasted amount to the whole dollar. June 3- June 30 Sales: This Year Sales Day June Datel Sales Day June Date Monday 3 $1417 Monday 17 Tuesday 4 1405 Tuesday 18 Wednesday 5 1385 Wednesday 19 Thursday 6 1330 Thursday 20 Friday 7 1785 Friday 21 Saturday 8 1810 Saturday 22 Sunday 9 1770 Sunday 23 Monday 10 1627 Monday 24 Tuesday 11 1587 Tuesday 25 Wednesday 12 1455 Wednesday 26 Thursday 13 1490 Thursday 27 Friday 14 1820 Friday 28 Saturday 151 1775 Saturday 29 Sunday 161 1810 Sunday 30 $1571 1522 1329 1510 1885 1890 1900 1482 1491 1610 1555 2305 2015 1885 4-Week Average July 1-7 Forecast Janice's 4-Week Average Forecast worksheet Week Week Sales 1 2 Week 3 Week 4 IS s Is $ Monday 1417 1627 1571 1482 Tuesday Wednesday Thursday Friday Saturday Sunday Total Daily Average

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Audit Is A Powerful Management Tool

Authors: Fateh Bouchene

1st Edition

6204366548, 978-6204366548

More Books

Students also viewed these Accounting questions