Posted: September 11th, 2023
Attached is a simple business model for a bakery selling doggy themed treats. It sells Cupcakes, Cakes, and Biscuit Bites. There are three locations, it is looking to close the location of the Fremont Store. They are also in the process of renaming the store. They need a ton of help:
1. Attached is a spreadsheet of the model, assume the Cupcakes sell for $2, Cakes sell for $20, and Biscuit Bites sell for $4, calculate the amount of revenue for each product and its totals.
2. Calculate the total and average amounts of units sold for each product line using functions.
3. What is the impact in terms of total units of each product if there were to close the Fremont Store?
4. Use a bar graph that illustrates the number of each units sold by City location AND another bar graph by product line, showing sales in each city. Include the following elements into your charts: Legend, Data Series (showing the value of each bar), vertical Assignment 1 – Excel 46B.xlsx
Download Assignment 1 – Excel 46B.xlsx
and horizonal axis labels, tickmarks and gridlines. Please include each of these charts as a separate sheet in your workbook.
5. They are also thinking of changing their name and logo. Include a logo image from Google Search and a name for your bakery (hint, search for doggy themed deserts in Google images).
Place an order in 3 easy steps. Takes less than 5 mins.