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
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
- 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!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images