You have been provided the 2017 2019 sales revenue and units sold for Danis Dinnerware. Danis is in the process of preparing an annual revenue budget for 2020. Use the historical information as well as the information below to prepare the budget. The budget should consider units sold, average selling prices and attachment rates.

• Dani's Dinnerware manufactures and sells two types of dinnerware to retail stores; ceramic dinnerware and stoneware dinnerware.
• Dani's sells 4 piece place sets that include a dinner plate, a salad plate, a soup bowl and a coffee cup.
• Dani's also sells dinner plates, salad plates, soup bowls, and coffee cups separately.
• Dani's also sells larger serving platters, small serving platters and large serving bowls.
• Dani's has a very limited product line for its ceramic customers, which inhibits new customer growth.
• Dani's ceramic customers are very loyal.
• Dani's has historically developed new creative stoneware products in the very price sensitive stoneware market.
• The overall sales growth rate in the dinnerware market has been 2% over the past three years and is expected to remain at that level for 2020.
• Dani's has just signed up a new large warehouse customer for its stoneware products. This customer alone is expected to increase Dani's unit stoneware sales by 15%. The lower price offered this customer is expected to reduce Dani's average selling prices by 8 percentage points, in addition to any normal market price changes.

Your assignment is to:

• Prepare a 2020 revenue budget, with supporting worksheets.

Deliverable: Provide the requested information in an excel file. Add explanations and comments to spreadsheet as needed.

Dinnerware Revenue Forecasting Ceramic Dinnerware 4 Piece Place Sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total $ $ $ $ $ $ $ $ $ Sales Revenue 2017 2018 286,102.31 $ 318,928.16 $ 15,812.25$ 17,685.36 $ 11,460.80$ 12,680.00 $ 12,566.28 $ 13,872.87 $ 6,894.75$ 8,160.50 $ 83,724.96 $ 94,025.16 $ 85,175.04 $ 78,242.00 $ 106,490.22 $ 116,662.05$ 608,226.61 $ 660,256.10 $ 2019 345,206.40 19,051.20 13,574.40 15,498.65 8,426.88 100,321.76 77,275.26 129,541.77 708,896.32 Ceramic Dinnerware 4 Piece Place Sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total 2017 9,869 2,181 1,976 1,884 1,585 4,444 5,248 5,926 33,113 Units 2018 10,064 2,233 2,000 1,903 1,718 5,004 4,408 5,937 33,267 2019 10,274 2,268 2,020 2,005 1,672 5,269 3,891 6,219 33,618 Stoneware Dinnerware 4 Piece Place Sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total 2017 2018 2019 $ 509,130.57 $ 539,040.70 $ 584,831.52 $ 36,237.82 $ 35,882.07 $ 34,346.97 $ 28,681.00 $ 27,472.50 $ 27,116.78 $ 29,071.44 $ 28,181.70 $ 29,251.26 $ 17,279.55$ 17,322.16 $ 15,875.37 $ 206,134.40 $ 214,528.17$ 224,470.47 $ 218,259.02 $ 186,564.96 $ 182,037.60 $ 244,319.30 $ 267,878.52 $ 290,753.00 $ 1,289,113.10 $ 1,316,870.78 $ 1,388,682.97 Stoneware Dinnerware 4 Piece Place Sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total 2017 11,843 2,906 2,668 2,504 2,115 5,920 6,991 7,894 42,841 2018 12,406 3,059 2,750 2,595 2,344 6,249 6,026 8,806 44,235 2019 13,104 3,207 2,894 2,851 2,373 6,531 5,895 9,580 46,435 Total $ 1,897,339.71 $ 1,977,126.88 $ 2,097,579.29 Total 75,954 77,502 80,053 Dinnerware Revenue Forecasting Ceramic Dinnerware 4 Piece Place Sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total $ $ $ $ $ $ $ $ $ Sales Revenue 2017 2018 286,102.31 $ 318,928.16 $ 15,812.25$ 17,685.36 $ 11,460.80$ 12,680.00 $ 12,566.28 $ 13,872.87 $ 6,894.75$ 8,160.50 $ 83,724.96 $ 94,025.16 $ 85,175.04 $ 78,242.00 $ 106,490.22 $ 116,662.05$ 608,226.61 $ 660,256.10 $ 2019 345,206.40 19,051.20 13,574.40 15,498.65 8,426.88 100,321.76 77,275.26 129,541.77 708,896.32 Ceramic Dinnerware 4 Piece Place Sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total 2017 9,869 2,181 1,976 1,884 1,585 4,444 5,248 5,926 33,113 Units 2018 10,064 2,233 2,000 1,903 1,718 5,004 4,408 5,937 33,267 2019 10,274 2,268 2,020 2,005 1,672 5,269 3,891 6,219 33,618 Stoneware Dinnerware 4 Piece Place Sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total 2017 2018 2019 $ 509,130.57 $ 539,040.70 $ 584,831.52 $ 36,237.82 $ 35,882.07 $ 34,346.97 $ 28,681.00 $ 27,472.50 $ 27,116.78 $ 29,071.44 $ 28,181.70 $ 29,251.26 $ 17,279.55$ 17,322.16 $ 15,875.37 $ 206,134.40 $ 214,528.17$ 224,470.47 $ 218,259.02 $ 186,564.96 $ 182,037.60 $ 244,319.30 $ 267,878.52 $ 290,753.00 $ 1,289,113.10 $ 1,316,870.78 $ 1,388,682.97 Stoneware Dinnerware 4 Piece Place Sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total 2017 11,843 2,906 2,668 2,504 2,115 5,920 6,991 7,894 42,841 2018 12,406 3,059 2,750 2,595 2,344 6,249 6,026 8,806 44,235 2019 13,104 3,207 2,894 2,851 2,373 6,531 5,895 9,580 46,435 Total $ 1,897,339.71 $ 1,977,126.88 $ 2,097,579.29 Total 75,954 77,502 80,053