Woksheet that shows Kaitlyn’s Ice Cream Shoppe projected monthly sales Kaitlyn’s Ice Cream Shoppe Six-Month Financial Projection It includes the needs, source of data, summary of calculations, and chart requirements. The requirements document for the Kaitlyn’s Ice Cream Shoppe Six-Month Financial Projection worksheet is shown in Figure 3–2. Your touch screen differs slightly from this module’s presentation.
Office and Windows interfaces may vary if you are using a touch screen.įor this reason, you might notice that the function or appearance of To create a column chart that shows the breakdown of expenses for eachįigure 3–1(a) Worksheet (b) Clustered Column Chart To commission or the cost of the kiosk rentals. The worksheet should allowįor quick analysis, if projections for certain numbers change, such as Projections for the upcoming six months to use for procuring partialįinancing and for determining staffing needs. The CEO requires an easy-to-read worksheet that shows financial Upcoming six-month period, based on figures from the previous six Goods sold, gross margin, expenses, and operating income for the The chief executive officer projects monthly sales revenues, costs of Kaitlyn’s Ice Cream Shoppe operates kiosks at colleges and universitiesĪnd serves both hard and soft serve ice cream. The project in this module uses Excel to create the worksheet and clustered column chart shown in Figures 3–1a and 3–1b.
Information about how to change a computer’s resolution, refer to the Office and Windows module at the beginning of this book. In this module and you want your screens to match the figures in thisīook, you should change your screen’s resolution to 1366 x 768. You are using a computer or mobile device to step through the project Module at the beginning of this book, where you can learn how to run anĪpplication, use the ribbon, save a file, open a file, print a file,Įxit an application, use Help, and much more.
Project - Financial Projection Worksheet with What-If Analysis and Chartįor an introduction to Office and instructions about how to perform basic tasks in Office apps, read the Office and Windows