Reference no: EM132792881
FI 631 Financial Modeling - Bentley University
You have been provided with the 2018 - 2020 sales revenue and units sold for Dani's Dinnerware. Dani's is in the process of preparing an annual revenue budget for 2021. 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 2021.
• 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 11%. The lower price offered this customer is expected to reduce Dani'saverage sellingstoneware prices by 4 percentage points,in addition to any normal market price changes.
Your assignment is to:
• Prepare a 2021 revenue budget, with supporting worksheets.
Deliverable: Provide the requested information in an excel file. Add explanations and comments to spreadsheet as needed.
Attachment:- Financial Modeling.rar
|
Specific performances for return of the baseball
: At age seventeen, John Renslow, sells his baseball card collection on eBay to buy a new video game system. Two years later, Mark Renslow
|
|
How much will be in the deferred rent revenue account
: How much will be in the Deferred Rent Revenue account by the end of the year, after the adjusting entries have been prepared and posted?
|
|
Produce documents for various organizations
: Consider a Cloud-based publishing system used to produce documents for various organizations.
|
|
List five major developments in military technology
: List five major developments in military technology first used on a large scale in World War I. How did they affect the conduct of the war as reflected.
|
|
FI 631 Financial Modeling Assignment
: FI 631 Financial Modeling Assignment Help and Solution, Bentley University - Assessment Writing Service - Prepare a 2021 revenue budget
|
|
What is the company net working capital
: Accounts receivables of $3,489,287, notes payable worth $1,151,864, and other current assets of $122,063. What is the company's net working capital?
|
|
Quality measurement in healthcare
: What steps would you take to measure the current level of quality at the hospital?
|
|
What factors triggered the changes
: The American mood toward the war in Europe changed dramatically during the late 1910s, from division to patriotic support for the war effort.
|
|
How much money will have on the date of retirement
: Salary will increase at 3 percent per year throughout your career. How much money will you have on the date of your retirement 40 years from today?
|