Based off of the attached data I need summarize each department budget and note any large variances then Explain two variances that might cause concern. I also need to write a memo to the leadership team expaining the performance level of the press division and if it should continue operations.

CoursHeroTranscribedText

AutoSave Off 8 2.2 File Home Insert Page Layout Formulas Data Review View Help ACC 207 Final Project II Student Workbook-Popow - Saved Tell me what you want to do DENISE POPOW Share Comments AutoSum Arial - 12 ' = = = ab Wrap Text General 27 4 Fill- Paste BIU A Merge & Center $ - % 9500-00 Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort & Find & Ideas Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas A1 fx A 1 MOST LIKELY NUMBERS AND ASSUMPTIONS 2 SALES MANAGER PRIVATE INFORMATION 3 Most likely sales 4 5 6 MOST LIKELY NUMBERS AND ASSUMPTIONS 7 PURCHASING MANAGER PRIVATE INFORMATION 8 9 10 11 Most likely cost of merchandise as a % of sales Desired ending inventory as a percentage of next month's cost of sales B E F Home G H J K L M N 0 P Q R July $ August 600,000 $ 910,000 September October $ 475,000 $ 385,000 Part 1 Information 45% 20% 12 OPERATION MANAGER PRIVATE INFORMATION 13 Most likely shipping expenses as a percent of sales 14 Most likely other expenses as a percent of sales 15 Salaries and wages (per month) 16 Most likely advertising costs (per month) 17 Most likely insurance costs (per month) 18 19 20 Depreciation expense (per month) 21 FINANCE MANAGER PRIVATE INFORMATION 22 Percent sales collected in month of sale 23 Percent sales collected in month after sale 24 25 Percent of inventory purchases paid in month of purchase 26 Percent of inventory purchases paid in month after purchase 27 28 Percent of operating expenses paid in month of purchase Part 1 Information 5.0% 8.0% $ 85,000 $ 50,000 $ 3,000 $ 25,000 Part 1 Information 30% 70% 50% 50% 100% 29 Percent of operating expenses paid in month after purchase 0% 30 31 Desired minimum ending cash balance each month $ 35,000 32 Borrow in increments of 33 Monthly interest rate on borrowings (not compounded) $ 1,000 1% 34 35 36 Other planned outlays of cash July August September 37 Capital expenditures S 38 Dividends $ 200,000 $ 50,000 $ 90,000 Milestone One Instructions Part II Assumptions Sheet1 Part II Sales Budget Part II Purchasi Average: 237800.0948 Count: 97 Sum: 9512003.79 + 70%