Project 3 Su 2017 (4) Excel Minimize FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW AutoSum Calibri General .A. ___Merge & Center . S . % , hi..8 Conditional Format as Cell FormattingTable Styles Paste Insert Delete Format . Clear Sort & Find & Filter .. Select" Clipboard Font Alignment Number Cells Editing K6 0 6 Enter the last 4 digits of your student ID number: 5 7 hese digits will be used to calculate two variables 8 Save this file in EXCEL FORMAT as: P3Lastname 9Round all answers to whole numbers except cost per unit in Requirement 8 (round to nearest cent) 10 Do not change rows or columns on this spreadsheet. Input areas are in yellow 12 Requirement 1: 13 Perfect Pots, Inc. makes large, outdoor decorative flower pots that have the look of clay but are made from a polyresin 14 material that is much more durable. The controller for the company is working on the budget for the coming fiscal year, which 15 begins April 1. Sales in units for April are expected to be: 16 A as calculated below Multiply the highest digit from your student ID number above by 100 (if less than 5, use 5) = 18 19 sales are expected to increase by 10% each month through August. Each pot sells for $80. 20 21 Complete the Sales Budget for April - June and the quarter in total. Sales Budget 23 24 Sales in units 25 Price per unit 26 Total sales 27 28 Requirement 2: 29 The company wants to have 30 the following month on hand at the end of each month. Ma une Total % (as calculated below) of the flower pots that are expected to be sold There were 80 flower pots on hand at the end of March. B B. Multiply your lowest digit (other than 0) from your student ID number above by 10 and insert in the in the box provided: 32 34 35 Complete the Production Budget for April - June and the quarter in total 36 37 Production Budget 38 Sales in units 39 Desired ending invento 40 Total required Hint: You will need to calculate July's sales Ma June Totalin units in order to calculate the desired ending inventory for June. Sheet1 ENTER 100% 12:20 PM Type here to search 7/28/2017 1