4 Your 3M software license expense increases 4% per year. (Do not budget the 3.5% increase here as it is a 4% increase.) You need to investigate the purchase of a professional scanner that will not be considered a capital equipment purchase. Find a model, see if you can find multiple sites that provide information on the same product, compare pricing, and put the information in your attached documentation. Make sure you answer these questions: 3 # C 0 Did you find such a professional scanner; O How much will it cost; Will it qualify as a non-capital expense? What models did you evaluate, and explain why you are choosing this particular model. MacBook Pro G Search or type URL % & 6 29 7 85 $4 E R T Y U D F G H * 8 9 O Submit - O P J K L Page 2 > BUDGET PREPARATION You have been assigned the task of completing the proposed budget for the next fiscal year which is from January-December. You have the previous year's budget which includes salaries and other expenses. You need to use this historical data and other budget assumptions as stated below to prepare your department's budget for 2020. (Yes, I know we are already in April, 2020, but this makes it easier to find the information you need to enter into the budget.) Additional documentation must be submitted for many of the questions. Please provide the additional documentation as a Word document. The budget itself must be in Excel. The final Excel spreadsheet must include your new budgeted figures broken down by month with a total for the year. I will be checking formulas, so be sure and include them in appropriate cells. Be sure and use your budget assumptions in your calculations. Your spreadsheet should look something like this (this is an example): Proposed Budget for Griffon Hospital, 2020 Expense category 510000 Salaries 515000 Audit Expense and so forth Jan Feb Mar Apr and so forth Any notes Once your spreadsheet is finished answer these questions and put the question and answer at the bottom of the spreadsheet. Based on 2080 hours per employee, what is your department's average hourly salary rate? What is the total average monthly expense for your department each month? Based on calendar days in 2020, (be careful with this) what is the projected cost per day to run the department? MacBook Pro Search or type URL + rd [Solved] Assignment Objective x Budget Preparation 1. You ha x + com/courses/34857/assignments/361088?return_to=https%3A%2F%2Fmissouriwestern.instructure.com%2Fcal Page < 2 > What is the total average monthly expense for your department each month? Based on calendar days in 2020, (be careful with this) what is the projected cost per day to run the department? GRIFFON HOSPITAL, located in St. Joseph, MO. 2019 Budget Totals to be used to start budgeting process. Expense category 510000 Salaries $240,160 515000 Audit Expense $2750 560000 Purchased Services $98,000 565000 Maintenance contracts $2500 530000 Office Supplies $250 535000 Printing/postage/freight $1625 537000 Record Storage $7200 570000 Equipment repair $350 580000 3M Software license/Subscriptions $4480 567000 Telephone $250 575000 Professional dues (AHIMA) $555 576000 Travel $1200 577000 Education $50 529000 Minor Equipment $0 3