Certainly! Let’s break down the steps required to solve this scenario as described in your assignment. --- ## **Step-by-Step Solution** ### **Step 1: Understand the Requirements** You need to calculate the total cost per worker for: - **30 Desktop systems** (meeting minimum specs) - **15 Printers** (meeting minimum specs) - **30 Licenses each of:** - Microsoft Office 365 Business - Apache Open Office - Microsoft Windows 10 Pro **Note:** Every 2 workers share one printer, so only half a printer cost is attributed to each worker. --- ### **Step 2: Define the Specifications** #### **Desktop Minimum Specs:** - Processor speed: **3 GHz** - Hard drive: **500 GB** - RAM: **4 GB** - DVD-ROM drive: **DVD-RW** - Monitor: **18 inches** #### **Printer Minimum Specs:** - Print speed: **20 ppm** - Print resolution: **600 x 600** - Network ready: **Yes** - Maximum price: **$700** --- ### **Step 3: Research Prices** (You need to use current internet prices. For the sake of example, I'll assume reasonable average prices.) #### **Example Prices:** - **Desktop Systems:** $550 each (Lenovo, Dell, HP) - **Monochrome Printers:** $180 each (HP, Canon, Brother) - **Microsoft Office 365 License:** $100 per year per user - **Apache Open Office:** Free (open-source) - **Windows 10 Pro License:** $140 per user --- ### **Step 4: Calculate Costs** #### **A. Desktop Cost** \[ \text{Desktop cost per worker} = \frac{\text{Total desktop cost}}{30} \] \[ \text{Total desktop cost} = 30 \times \$550 = \$16,500 \] \[ \text{Desktop cost per worker} = \$16,500 / 30 = \$550 \] --- #### **B. Printer Cost** \[ \text{Total printer cost} = 15 \times \$180 = \$2,700 \] \[ \text{Printer cost per worker} = \frac{\text{Total printer cost}}{30} = \$90 \] (Or, equivalently, half a printer per worker: \$180/2 = \$90) --- #### **C. Software Cost** (over 2 years) ##### **Microsoft Office 365** \[ \text{Cost for 2 years} = 2 \times \$100 = \$200 \text{ per worker} \] \[ \text{Total Office 365 cost} = 30 \times \$200 = \$6,000 \] ##### **Apache Open Office** \[ \text{Cost} = \$0 \text{ per worker} \] ##### **Windows 10 Pro** \[ \text{Cost per worker} = \$140 \] \[ \text{Total Windows cost} = 30 \times \$140 = \$4,200 \] --- ### **Step 5: Calculate Total Cost Per Worker** #### **Option 1: Using Microsoft Office 365** \[ \text{Total per worker} = \$550 \text{ (desktop)} + \$90 \text{ (printer)} + \$200 \text{ (Office 365)} + \$140 \text{ (Windows 10 Pro)} \] \[ \boxed{\$980} \] #### **Option 2: Using Apache Open Office** \[ \text{Total per worker} = \$550 \text{ (desktop)} + \$90 \text{ (printer)} + \$0 \text{ (Open Office)} + \$140 \text{ (Windows 10 Pro)} \] \[ \boxed{\$780} \] --- ### **Step 6: Prepare Spreadsheet** Your spreadsheet should have columns for: - Item (Desktop, Printer, Office 365, Open Office, Windows 10) - Quantity - Unit Price - Total Price - Cost Per Worker --- ### **Step 7: Recommendation** - **Best Value:** Using Apache Open Office offers a lower cost per worker (\$780) compared to Microsoft Office 365 (\$980), assuming all other requirements are met (as Open Office is free). --- ## **Final Table Example** | Item | Quantity | Unit Price | Total Price | Cost Per Worker | |----------------|----------|------------|-------------|-----------------| | Desktop | 30 | $550 | $16,500 | $550 | | Printer | 15 | $180 | $2,700 | $90 | | MS Office 365 | 30 | $200* | $6,000 | $200 | | Open Office | 30 | $0 | $0 | $0 | | Windows 10 Pro | 30 | $140 | $4,200 | $140 | *($100 per year × 2 years) --- ## **Final Answer** - **Total Cost Per Worker using Microsoft Office 365:** **\$980** - **Total Cost Per Worker using Apache Open Office:** **\$780** --- **Note:** Use actual prices from your research for your final submission. This is a sample calculation for illustration. Prepare your spreadsheet accordingly and include all group member names and student numbers on the first slide.