Excel Questionnaire

User Generated

funqnr

Business Finance

Description

1. A laptop company has discovered its cost and revenue functions for each day: C(Q) = 3Q2 – 10Q + 200 and R(Q) = ?2Q2 + 100Q + 50. If they want to make a profit, what is the range of laptops (Q) per day that they should produce? Round to the nearest number which could generate profit. Find the Profit Function. Use the formula (- b/2a) to find max profit


2. A manufacturer produces two products, A and B. For each unit of A sold the profit is $8. For each unit of B sold the profit is $11. From past experience it has been found that 25 percent more of A can be sold than of B. Next year the manufacturer desires a total profit of $42,000. How many units of each product must be sold? ( Please type work )


3.A company's revenue and cost in dollars are given by R = 645Q and C = 45Q + 180,000, where Q is the number of items. What is the Fixed Cost of Production? Find the number of items that must be produced to break-even.

  1. what is the total profit for producing and selling 800 units?

Unformatted Attachment Preview

FINISH STRONG ? Putting It Together Quiz Results 2. In the section DIVE IN, complete modules 5-7, "Statistical Functions and Formuas", "Add-ins" and "Internet and Excel". 3. in the section FINISH STRONG, complete the modules "Putting It Together" and "Ready for the Quiz". 4. After you finish the Study Plan materials, navigate back to this Blackboard folder and click on the Quiz link to take the quiz. Your score which will be posted automatically in "My Grades" in Blackboard. Topics covered: . • Introduction to Statistical Functions and Formulas • What is a Function? Lookup Functions and Formulas Logical Functions and Formulas • Financial Functions and Formulas Introduction to Add-Ins • Add-Ins • Introduction to Internet and Excel • Internet and Excel • Putting It Together: Microsoft Excel Advanced Skills . Quiz: Microsoft Excel Advanced Skills LAB ASSIGNMENT: CREATE LOOKUP FUNCTIONS Attached Files: MegaCorp-Sales-Data-VLookup-Assignment-CIS101.xlsx (594.926 KB) In this assignment, you will practice the most commonly-used lookup function, VLOOKUP. Download the attached file MegaCorp-Sales-Data-VLookup-Assignment-CIS101. You may recognize these sales data from the previous week's pivot exercise. However, in this file the Product names have been filled in by using the VLOOKUP function to retrieve the name from the Product List sheet, based on the ProductID. Use VLOOKUP to retrieve each Salesperson's name, Title and Commission rate from the Salesperson List, based on the SPID (Salesperson ID). Save the file with your name included in the filename and submit.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please view exp...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags