AssignmentDani's Dinnerware manufactures and sells two types of dinnerware to retail stores; ceramic dinnerware and stonewaredinnerware.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 separatelyDani'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 increaseDani's unit stoneware sales by 15%. The lower price offered this customer is expected to reduce Dani's average selling prices by 5percentage points, beyond any normal market price changes. Dinnerware Revenue ForecastingSales RevenueUnitsCeramic Dinnerware201620172018Ceramic Dinnerware201620172018286,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 SetsDinner Plates4 Piece Place Sets344,870.409,86610,06310,2642,222Dinner Plates2,26018,984.002,1711,973$12,506.25 $Salad PlatesSalad Plates2,01011,443.4013,507.201,999Soup BowlsCoffee CupsLarge Serving PlatterSmall Serving PlatterLarge Serving BowlSoup BowlsCoffee Cups15,436.811,8751,9971,892$6,868.65 $83,649.60 $1,5791,6668,396.641,711Large Serving Platter4,9995,263100,201.924,44085,093.89 $Small Serving Platter4,4003,88577,156.105,243$106,382.40 $Large Serving Bowl5,9205,932129,375.136,211$659,688.10$Total Ceramic UnitsTotal Ceramic Revenue33,06733,556607,699.28707,928.2033,218201720182017Stoneware Dinnerware2016Stoneware Dinnerware20162018508,958.61 $4 Piece Place Sets538,780.00 $12,4004 Piece Place Sets13,100584,653.0011,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 PlatesDinner Plates3,0503,20234,293.422,902Salad PlatesSalad Plates2,6662,88527,032.452,740Soup BowlsCoffee Cups$29,059.83 $$Soup Bowls29,138.402,5032,5892,840Coffee Cups17,206.02 $15,848.612,1062,3412,369Large Serving PlatterSmall Serving Platter$205,925.48 $218,165.36 $Large Serving Platter6,2386,521224,126.775,914Small Serving Platter6,988181,821.446,0195,888$244,164.55 $$ 1,288,327.29267,665.58 $$1,315,509.99Large Serving BowlLarge Serving Bowl290,419.157,88942,8078,79944,1769,569$ 1,387,333.24Total Stoneware UnitsTotal Stoneware Revenue46,374$1,896,026.57 $1,975,198.09 $ 2,095,261.44Total RevenueTotal Units75,87477,39479,930S

Question
Asked Oct 12, 2019
  • 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.
help_outline

Image Transcriptionclose

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.

fullscreen
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
help_outline

Image Transcriptionclose

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

fullscreen
check_circleExpert Solution
Step 1

Compute overall increase in unit sales growth for din...

Sales
Sales
growth units in
Sales
2018
growth
rate (B) (C=AXB)
in units
2019
Ceramic Dinnerware
4 Piece place sets
Dinner Plates
Salad Plates
Soup Bowls
Coffee Cups
Large Serving Platter
Small Serving Platter
|Large Serving Bowl
Total ceramic units
units (A)
10,264
(A+C)
10,469
2,305
2,050
40
2%
205
29%
2,260
45
2,010
1,997
1,666
5,263
2%
40
2%
2,037
1,699
5,368
3,963
2%
33
2%
105
3,885
2%
78
2%
6.211
124
6.335
33,556
34,227
Sales
Sales
growth units in
Sales
2018
growth
in units
2019
Stoneware Dinnerware units (A) rate (B) (C=AxB)
4 Piece place sets
Dinner Plates
Salad Plates
Soup Bowls
Coffee Cups
Large Serving Platter
Small Serving Platter
Large Serving Bowl
Total Stoneware units
(A+C)
262 13,362
13,100
3,202
2,885
2,840
2,369
6,521
5,888
2%
2%
64
3,266
2%
58
2,943
2%
57
2,897
2,416
6,651
6,006
9.760
47,301
2%
47
2%
130
2%
118
9.569
2%
191
46,374
help_outline

Image Transcriptionclose

Sales Sales growth units in Sales 2018 growth rate (B) (C=AXB) in units 2019 Ceramic Dinnerware 4 Piece place sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter |Large Serving Bowl Total ceramic units units (A) 10,264 (A+C) 10,469 2,305 2,050 40 2% 205 29% 2,260 45 2,010 1,997 1,666 5,263 2% 40 2% 2,037 1,699 5,368 3,963 2% 33 2% 105 3,885 2% 78 2% 6.211 124 6.335 33,556 34,227 Sales Sales growth units in Sales 2018 growth in units 2019 Stoneware Dinnerware units (A) rate (B) (C=AxB) 4 Piece place sets Dinner Plates Salad Plates Soup Bowls Coffee Cups Large Serving Platter Small Serving Platter Large Serving Bowl Total Stoneware units (A+C) 262 13,362 13,100 3,202 2,885 2,840 2,369 6,521 5,888 2% 2% 64 3,266 2% 58 2,943 2% 57 2,897 2,416 6,651 6,006 9.760 47,301 2% 47 2% 130 2% 118 9.569 2% 191 46,374

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour*

See Solution
*Response times may vary by subject and question
Tagged in

Business

Accounting

Budgeting

Related Accounting Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: What information from the income statement and balance sheet would help a manager for a musical grou...

A: Income statement and balance sheet are the two most important financial statements that help the man...

question_answer

Q: I need assistance on the following regarding the attached balance sheet and income statement: Requir...

A: Click to see the answer

question_answer

Q: Zack Gaddis owns and operates Gaddis Advertising Services. On January 1, 2018, Zack Gaddis, Capital ...

A: Equity represents the amount owned by the contributors of capital. Equity balance includes all the a...

question_answer

Q: How do i figure out what goes where? I've been stumped for the past half hour

A: Requirement (A) 

question_answer

Q: Direct Labor Cost Budget MatchPoint Racket Company manufactures two types tennis rackets, the Junior...

A: Direct labor budget: A direct labor budget demonstrates the direct labor hours and its associated co...

question_answer

Q: Taxable income and pretax financial income would be identical for Marin Co. except for its treatment...

A: Journal entries for 2016,2017 and 2018.

question_answer

Q: Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for prepaid cell phone...

A: First-in-First-Out: In First-in-First-Out method, the costs of the initially purchased items are con...

question_answer

Q: Unexpired insurance is $1,000 , how do I put that into adjustments and adjusted trial balance ?

A: Unexpired insurance is a current asset (prepaid assets). When it is expired the following entry will...

question_answer

Q: 000 i na 55. Selected accounts of Farm Company are shown below as of January 31 of the current year,...

A: Adjusting entries: Adjusting entries are those entries which are recorded at the end of the year, to...