pleaseee pleaseee explain this assignment

Suppose you manage the sales and marketing department at a company that generates $100 million insales?amanufacturer of fireplace inserts and related equipment. Assume you just started the job and that at the end of your second day the corporate operations officer (COO) sticks her head into your office and announces, "I'm in a rush and have to go, but I wanted to let you know that I put $80,000 in the budget for computers for your department next year. Is that OK? Unfortunately,I'vegot to know by the day after tomorrow. Thanks."

How do you respond? You have 2 days to decide. If you agree to the $80,000 and it turns out to be insufficient, then sometime next year your department will lack computing resources and you'll have a management problem. If that happens, you may have to spend over your budget. You know that cost control is important to your new employer, so you dread overspending. However, if you ask for more than $80,000, you need to justify why you need it. You will need to document the computer equipment and software your department needs, explain why you need it, and estimate how much it will cost.

Here is what you know so far:

• The IT Department will be upgrading all of your department's computers to Windows 10 and Office 2016 in the next year. IT has negotiated a site license for these products, and then allocates that license cost to each computer. For your department, you will pay $100 for each computer that uses Office 2016 and another $75 for each computer that uses Windows 10.
• You are not required nor allowed to buy any software for new computers. If the computer comes with software, that software will be destroyed by the IT department's standard installation process.
• The IT department assesses each computer an annual $950 fee for network, server, and other overhead costs.
• Youare required to buyany new computers and equipment fromDell, HP, orLenovo(Hint use theBusiness product pages, not Gaming or Personal prices)
• You have identified three classes of computer users in your department. The main memory, RAM, and disk storage requirements for each class of user are shown in Figure 4-19. This figure shows the specifications of existing computers as well as the hardware requirements for each class after the upgrade.
• Figure 4-20 in your book shows the job titles of employees in your department, the number of employees of each type, the class of computer they require, and whether they use a desktop or a laptop. (You are a new employee, do not yet have a computer, and can specify your own requirements.)
• A computer can be reassigned to other employees as long as the computer meets the minimum processing requirements. A laptop can substitute for a desktop if a display, keyboard, and mouse are purchased to go with it.
• Assume thattelesalespersonnel will grow by 10 percent in the next year but there will be no other changes in the number of personnel in your department.
• Ten of the existing class B computers have a maximum main memory of 4GB. The rest of the class B computers have a maximum main memory of 2GB. All of the existing class C computers have a maximum main memory of 4GB.

To do:

1. Given this data, is $80,000 enough? If not, how much money should be allocated in your department?a brief answer documenting your assumptions for your boss in the Write Submission area.
2. Develop and attach a Spreadsheet anduse formulas/functionsto assist you with this analysis.Remember you will have to give this spreadsheet to your new boss so make it professional, with titles, formatting, etc.You will also want to save this spreadsheet so that you will have documentation of your input data, calculations, and conclusions so you can discuss it with the boss. If you would like to work in a group of two people on this assignment you may.Please put both names on the assignment and each person should submit a copy.

Bb CONNECT - CCSU41150.201 X Home - Liferay X Bb Upload Assignment: Is $80,( x C Suppose You Manage The S x * Homework Help - Q&A from x 80,000 enough exercise upd X -> C @ https://ctccs.blackboard.com/webapps/assignment/uploadAssignment?content_id=_4801575_1&course_id=_83147_1&user_id=_158683_1 Need Help Getting Started? Use to learn more about hardware needs and a business, closely review the reading. Begin by sketching out your spreadsheet columns and rows. What data are you organizing? How does it relate to each other? Check off each item that you know as your complete it. For example, what three classes of computer users did you identify? Please note: You can exceed the specs listed above. Again, use the prices on the small/medium business pages, you will find a lower spec, less expensive computer. Figure 4-19 Hardware Specifications Current Hardware Specifications Required Hardware Specifications Class of Computer (Main Memory, Processor, Disk) (Main Memory, Processor, Disk) A 1GB, 1GHz, 80GB 4GB, 2.3GHz, 100GB B 2GB, 2GHz, 150GB 8GB, 2.7GHz, 250GB 4GB, 2.3GHz, 250GB 16GB, 3.3GHz, 500GB Job Title Number of Computer System Figure 4-20 Employees Required Computer Type Department Employees and Computer Requirements Product manage 8 Laptop Telesales 12 Desktop Department administrator A Desktop Marketing communications Laptop manager Marketing analyst C(desktop) Both, a desktop and B (laptop) laptop for each analyst Marketing programs B Desktop manager You 7?? 727 80,000 enough exercise updated.pdf ASSIGNMENT SUBMISSION Cancel Save Draft Submit