Use the Table Below to Answer the Following Question(s)

question 16

Multiple Choice

Use the table below to answer the following question(s) .

-Bolton Computers are planning to release a new line of low-end laptops.Using Excel's Solver, develop a nonlinear model to calculate the optimal price for the laptops, given that sales = -3.85 × price + 1150.9.

• A)342.40
• B)380.90
• C)719.70
• D)149.47

---

Definitions:

Semimonthly

Two times a month.

Spreadsheet Formula

A mathematical expression used in a spreadsheet program to perform calculations, analyze data, or automate tasks.

Yearly Pension

The annual amount paid to a retired employee, typically funded by previous contributions from the employer and/or the employee.

Formulas

Predefined mathematical equations used to calculate values based on input data, widely used in disciplines such as finance, physics, and chemistry.