Remember: You are an intern at the local branch office of WidgetsUnited, which is in need of new computers for their twenty employees. Their current computers (Optiplex 620) are 16 years old and cannot support Windows 10. The budget has been set to $25,000.00 for the new computers. (Note: they all have decent monitors, so those need not be replaced). Your supervisor tasked you with researching what’s available and at what cost.
Excel is a powerful application that helps you showcase your data accurately and efficiently to make informed financial decisions.
proposal in Excel:
Research sample business proposals using Excel on the internet to get an idea of spreadsheet structure.
Find more systems and present at least 20 rows of systems.
Apply the following features:
Absolute and relative cell references
Use appropriate formulas and functions (Example: Create a Total column and an absolute reference for the tax rate).
Apply Tax rate of 8.25%.
Conditional Formatting and Filters
Subtotals, groups, or filters, outlines for tabular data
Font attributes, borders, fill, cell styles, and themes
Charts, graphs, visuals
Visibly indicate your recommended PC
Grading will include clarity and comprehension of Office features. Your submission must also be informative and aesthetically pleasing. Check for spelling and grammar! Scoring will consider the minimum requirements and the following:
Fluency: Quantity of additional features included outside the minimum
Flexibility: Variety of additional features included outside the minimum
Originality: Rarity or unusualness of additional features included outside the minimum
Elaboration: Level of detail of additional features included outside the minimum
Readability: Content presentation such as font choice, spacing, and colors is mindful of ADA compliance
Mechanics: Accurate spelling, punctuation, capitalization, and grammar
When items one and two above are complete, zip your files into one and name it with your last name and “_recommendation_revised”. ([Name]_recommendation_revised.zip). Upload here in Bb when done.
FINAL NOTE: SafeAssign is placed on this assignment. Do NOT plagiarize or exceed 15 percent of your content work. Refereces do not count.