Assignment 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 unit sales growth rate in the dinnerware market is 2% per year. 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 5 percentage points, beyond any normal market price changes. Dinnerware Revenue Forecasting Sales Revenue Units Ceramic Dinnerware 2016 2017 2018 Ceramic Dinnerware 2016 2017 2018 286,015.34 $ 15,739.75 $ 318,896.47 $ 17,598.24 $ 12,673.66 $ 13,792.68 $ 8,127.25 $ 93,936.00 $ 78,100.00 $ 116,563.80 $ $ 4 Piece Place Sets Dinner Plates 4 Piece Place Sets 344,870.40 9,866 10,063 10,264 2,222 Dinner Plates 2,260 18,984.00 2,171 1,973 $ 12,506.25 $ Salad Plates Salad Plates 2,010 11,443.40 13,507.20 1,999 Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Soup Bowls Coffee Cups 15,436.81 1,875 1,997 1,892 $ 6,868.65 $ 83,649.60 $ 1,579 1,666 8,396.64 1,711 Large Serving Platter 4,999 5,263 100,201.92 4,440 85,093.89 $ Small Serving Platter 4,400 3,885 77,156.10 5,243 $ 106,382.40 $ Large Serving Bowl 5,920 5,932 129,375.13 6,211 $ 659,688.10 $ Total Ceramic Units Total Ceramic Revenue 33,067 33,556 607,699.28 707,928.20 33,218 2017 2018 2017 Stoneware Dinnerware 2016 Stoneware Dinnerware 2016 2018 508,958.61 $ 4 Piece Place Sets 538,780.00 $ 12,400 4 Piece Place Sets 13,100 584,653.00 11,839 $ 36,187.94 $ 28,659.50 $ 35,776.50 $ 27,372.60 $ 28,116.54 $ 17,299.99 $ 214,150.54 $ 186,348.24 $ Dinner Plates Dinner Plates 3,050 3,202 34,293.42 2,902 Salad Plates Salad Plates 2,666 2,885 27,032.45 2,740 Soup Bowls Coffee Cups $ 29,059.83 $ $ Soup Bowls 29,138.40 2,503 2,589 2,840 Coffee Cups 17,206.02 $ 15,848.61 2,106 2,341 2,369 Large Serving Platter Small Serving Platter $ 205,925.48 $ 218,165.36 $ Large Serving Platter 6,238 6,521 224,126.77 5,914 Small Serving Platter 6,988 181,821.44 6,019 5,888 $ 244,164.55 $ $ 1,288,327.29 267,665.58 $ $1,315,509.99 Large Serving Bowl Large Serving Bowl 290,419.15 7,889 42,807 8,799 44,176 9,569 $ 1,387,333.24 Total Stoneware Units Total Stoneware Revenue 46,374 $1,896,026.57 $1,975,198.09 $ 2,095,261.44 Total Revenue Total Units 75,874 77,394 79,930 S

Financial And Managerial Accounting
15th Edition
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:WARREN, Carl S.
Chapter7: Internal Control And Cash
Section: Chapter Questions
Problem 4MAD
icon
Related questions
icon
Concept explainers
Question
  • Prepare a 2019 revenue budget, with necessary supporting worksheets.

Using Excel would be ideal for this, and I attached two screenshots of all the information needed. Please help that would be so great!

Assignment
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 unit sales growth rate in the dinnerware market is 2% per year.
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 5
percentage points, beyond any normal market price changes.
Transcribed Image Text:Assignment 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 unit sales growth rate in the dinnerware market is 2% per year. 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 5 percentage points, beyond any normal market price changes.
Dinnerware Revenue Forecasting
Sales Revenue
Units
Ceramic Dinnerware
2016
2017
2018
Ceramic Dinnerware
2016
2017
2018
286,015.34 $
15,739.75 $
318,896.47 $
17,598.24 $
12,673.66 $
13,792.68 $
8,127.25 $
93,936.00 $
78,100.00 $
116,563.80 $
$
4 Piece Place Sets
Dinner Plates
4 Piece Place Sets
344,870.40
9,866
10,063
10,264
2,222
Dinner Plates
2,260
18,984.00
2,171
1,973
$
12,506.25 $
Salad Plates
Salad Plates
2,010
11,443.40
13,507.20
1,999
Soup Bowls
Coffee Cups
Large Serving Platter
Small Serving Platter
Large Serving Bowl
Soup Bowls
Coffee Cups
15,436.81
1,875
1,997
1,892
$
6,868.65 $
83,649.60 $
1,579
1,666
8,396.64
1,711
Large Serving Platter
4,999
5,263
100,201.92
4,440
85,093.89 $
Small Serving Platter
4,400
3,885
77,156.10
5,243
$
106,382.40 $
Large Serving Bowl
5,920
5,932
129,375.13
6,211
$
659,688.10
$
Total Ceramic Units
Total Ceramic Revenue
33,067
33,556
607,699.28
707,928.20
33,218
2017
2018
2017
Stoneware Dinnerware
2016
Stoneware Dinnerware
2016
2018
508,958.61 $
4 Piece Place Sets
538,780.00 $
12,400
4 Piece Place Sets
13,100
584,653.00
11,839
$
36,187.94 $
28,659.50 $
35,776.50 $
27,372.60 $
28,116.54 $
17,299.99 $
214,150.54 $
186,348.24 $
Dinner Plates
Dinner Plates
3,050
3,202
34,293.42
2,902
Salad Plates
Salad Plates
2,666
2,885
27,032.45
2,740
Soup Bowls
Coffee Cups
$
29,059.83 $
$
Soup Bowls
29,138.40
2,503
2,589
2,840
Coffee Cups
17,206.02 $
15,848.61
2,106
2,341
2,369
Large Serving Platter
Small Serving Platter
$
205,925.48 $
218,165.36 $
Large Serving Platter
6,238
6,521
224,126.77
5,914
Small Serving Platter
6,988
181,821.44
6,019
5,888
$
244,164.55 $
$ 1,288,327.29
267,665.58 $
$1,315,509.99
Large Serving Bowl
Large Serving Bowl
290,419.15
7,889
42,807
8,799
44,176
9,569
$ 1,387,333.24
Total Stoneware Units
Total Stoneware Revenue
46,374
$1,896,026.57 $1,975,198.09 $ 2,095,261.44
Total Revenue
Total Units
75,874
77,394
79,930
S
Transcribed Image Text:Dinnerware Revenue Forecasting Sales Revenue Units Ceramic Dinnerware 2016 2017 2018 Ceramic Dinnerware 2016 2017 2018 286,015.34 $ 15,739.75 $ 318,896.47 $ 17,598.24 $ 12,673.66 $ 13,792.68 $ 8,127.25 $ 93,936.00 $ 78,100.00 $ 116,563.80 $ $ 4 Piece Place Sets Dinner Plates 4 Piece Place Sets 344,870.40 9,866 10,063 10,264 2,222 Dinner Plates 2,260 18,984.00 2,171 1,973 $ 12,506.25 $ Salad Plates Salad Plates 2,010 11,443.40 13,507.20 1,999 Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Soup Bowls Coffee Cups 15,436.81 1,875 1,997 1,892 $ 6,868.65 $ 83,649.60 $ 1,579 1,666 8,396.64 1,711 Large Serving Platter 4,999 5,263 100,201.92 4,440 85,093.89 $ Small Serving Platter 4,400 3,885 77,156.10 5,243 $ 106,382.40 $ Large Serving Bowl 5,920 5,932 129,375.13 6,211 $ 659,688.10 $ Total Ceramic Units Total Ceramic Revenue 33,067 33,556 607,699.28 707,928.20 33,218 2017 2018 2017 Stoneware Dinnerware 2016 Stoneware Dinnerware 2016 2018 508,958.61 $ 4 Piece Place Sets 538,780.00 $ 12,400 4 Piece Place Sets 13,100 584,653.00 11,839 $ 36,187.94 $ 28,659.50 $ 35,776.50 $ 27,372.60 $ 28,116.54 $ 17,299.99 $ 214,150.54 $ 186,348.24 $ Dinner Plates Dinner Plates 3,050 3,202 34,293.42 2,902 Salad Plates Salad Plates 2,666 2,885 27,032.45 2,740 Soup Bowls Coffee Cups $ 29,059.83 $ $ Soup Bowls 29,138.40 2,503 2,589 2,840 Coffee Cups 17,206.02 $ 15,848.61 2,106 2,341 2,369 Large Serving Platter Small Serving Platter $ 205,925.48 $ 218,165.36 $ Large Serving Platter 6,238 6,521 224,126.77 5,914 Small Serving Platter 6,988 181,821.44 6,019 5,888 $ 244,164.55 $ $ 1,288,327.29 267,665.58 $ $1,315,509.99 Large Serving Bowl Large Serving Bowl 290,419.15 7,889 42,807 8,799 44,176 9,569 $ 1,387,333.24 Total Stoneware Units Total Stoneware Revenue 46,374 $1,896,026.57 $1,975,198.09 $ 2,095,261.44 Total Revenue Total Units 75,874 77,394 79,930 S
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning