AB1 Given Information:23456789 Decision Variable:101112 Uncertain Variable:13Daily Demand14151617Copier RentalStore CostPriceCDVariable CostMax Production per CopierDays Business is Open# of Copiers to RentWorkspace: Calculate Annual Copies SoldMaximum Annual ProductionEstimated Annual DemandActual Amount of Copies Sold181920 Objective: Calculate Annual Profits21RevenueE$5,000.00 per year$4,800.00 per year$0.10 per copy$0.03 per copy100000 copies365 daysF3 copiers1500 copies per day300,000544500GHThis is a veryproblem. Youhow much thbased on dem E18JxABC12 Uncertain variable:13Daily Demand1415 Workspace: Calculate Annual Copies Sold16Maximum Annual Production17Estimated Annual Demand18Actual Amount of Copies SoldD1920 Objective: Calculate Annual Profits212223242526272829303132RevenueStore CostsTotal Copier Rental CostTotal Variable CostE1500 copies per day300,000544500FProfitIf you get a value of $1,200 for profit inPart 1 the spreadsheet is almost surelyGThis is a very important cell in thisproblem. You use a formula to determinehow much the company can actually sellbased on demand AND maximumproduction capacity! There are a lot ofdifferent functions you can use (IF forexample), but I chose to use the MINOnce you have all of the sections aboveorganized and completed correctly, thecost and revenue calculations should beeasy, linking the cells for actual copiessold and # of copiers rented to thefinancial information given in the

Workspace: Calculate Annual Copies Sold Maximum Annual Production Estimated Annual Demand Actual Amount of Copies Sold Objective: Calculate Annual Profits Revenue Store Costs Total Copier Rental Cost Total Variable Cost 300,000 544500 Profit If you get a value of $1,200 for profit in Part 1 the spreadsheet is almost surely This is a very important cell in this problem. You use a formula to determine how much the company can actually sell based on demand AND maximum production capacity! There are a lot of different functions you can use (IF for example), but I chose to use the MINI Once you have all of the sections above organized and completed correctly, the cost and revenue calculations should be easy, linking the cells for actual copies sold and # of copiers rented to the financial information given in the

Workspace: Calculate Annual Copies Sold Maximum Annual Production Estimated Annual Demand Actual Amount of Copies Sold Objective: Calculate Annual Profits Revenue Store Costs Total Copier Rental Cost Total Variable Cost 300,000 544500 Profit If you get a value of $1,200 for profit in Part 1 the spreadsheet is almost surely This is a very important cell in this problem. You use a formula to determine how much the company can actually sell based on demand AND maximum production capacity! There are a lot of different functions you can use (IF for example), but I chose to use the MINI Once you have all of the sections above organized and completed correctly, the cost and revenue calculations should be easy, linking the cells for actual copies sold and # of copiers rented to the financial information given in the

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

Question 7 Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below. Sales ($) 1-5,999.99 6,000–29,999.99 30,000 and over Commission 10% of sales $600 plus 13% of the sales over 6,000 $3,720 plus 14% of the sales over 30,000 Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000. $700 if the salesperson travels. Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total due.
A company decided to give bonus to employee according to following criteria: Time period of Service Bonus More than 10 years 10% >=6 and <=10 8% Less than 6 years 5% Ask user for their salary and years of service and print the net bonus amount.
auto workshop is a vehicle service center located in the city of Muscat, which provides vehicle maintenance/repair services. The charges of vehicle maintenance/repair are based on the type of the service. Details of charges are as follow: Basic Tuning: 50 OMR Software Re-installation: 60 OMR Parts Replacement: 100 OMR Body Paint: 120 OMR The workshop offers 10% discounts to the customers who have membership of the service center. You are required to draw a flow chart diagram and write a C++ computer program that takes customer’s name, car plate number, membership status(Y/N) and the required service (mentioned above). The program outputs the input data and maintenance charges based on the service provided by the service center with discount, if applies.
Excel: Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded. Code Asset Type Quantities of Shares Traded ABCB4 ABC BRASIL PN N2 20 EALT4 ACO ALTONA PN 30 AELP3 AES ELPA ON 23 TIET3 AES TIETE E ON N2 65 TIET4 AES TIETE E PN N2 34 TIET11 AES TIETE E UNT N2 28 BRGE8 ALFA CONSORC PND 122 BRIV4 ALFA INVEST PN 133 ALSC3 ALIANSCE ON NM 45 ALPA3 ALPARGATAS ON N1 80
Use the table below to answer the questions in Group B. Lawn Service Comparisons (unless otherwise noted, dollars are yearly) Mowing, Trimming, Bagging (if necessary) May 1st through Oct. 31st Lawn Lawn Service Service A $1040 $125/cut $2.50/linear foot Trimming Bushes, Hedges included Lawn Fertilizations, and Aeration $170 $225 Weed and Seeding Control Fall and Spring Raking and Clean-Up $20/application included $205 $475
Model Vin Price VEHICLE CAR TRUCK SUV Engine_size Tonnage No_seats VEHICLE Vin price Model CAR Vin engine_size TRUCK Vin Tonnage SUV Vin No Seats CAR TRUCK SUV Vin price Model engine_size Vin price Model Tonnage Vin price Model No Seats VEHICLE Vin price Model Vehicle Type engine_size Tonnage No Seats VEHICLE Vin price Model Is_Car engine_size Is_Truck Tonnage Is_SUV No_Seats Consider this ER diagram and 4 possible options: Using option B or C: Implement one by showing the create table(s) statement. If you select B, write the trigger that ensures a VIN can only appear in one table. If you select C, write the trigger that requires the data associated with a particular Vehicle Type is not null, and sets the other data to null. Provide at least 3 sample data that demonstrates your trigger is working as expected.
Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below. Sales ($) Commission 1–5,999.99 10% of sales 6,000–29,999.99 $600 plus 13% of the sales over 6,000 30,000 and over $3,720 plus 14% of the sales over 30,000 Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000. $700 if the salesperson travels. Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total due
You are the manager of a Best Buy and you would like to see how much profit you made from your store over the past three months. Below is a worksheet which shows the 'Total Sales' in October 2019, November 2019, and December 2019. A 1 2 3 4 5 October 2019 November 2019 December 2019 2019 TOTAL SALES B DVD Sales 516 439 400 C CD Sales 355 750 751 1355 1856 D Record Sales 50 60 70 180 E TOTAL SALES Write a formula for cell E2 using the SUM function to calculate the TOTAL (DVD Sales, CD Sales, and Record Sales) for October 2019. When creating the formula, keep in mind that it will be copied to cells E3, E4, and E5 without modification. Now that you have written à formula for E2, write the formulas for E3, E4, and E5. 4
Question 31 A survey on pollution has been conducted on four cities. The degree of pollution is classified as not polluted, moderately polluted, and heavily polluted. The results of the survey are illustrated in the table below: City city1 city2 city3 city4 Xi1: not polluted 0.3 0.2 0.1 0.7 X12: moderately polluted 0.4 0.2 0.2 0.4 Xi3: heavily polluted 0.3 0.6 0.5 0.1 Use the cosine amplitude method to develop the fuzzy relation R that relates the pollution degree to the city.
What are percentiles and quartiles ?
Make a change, Total = 9 Available Coin Set = { 2, 3, 5 } using dynamic approach
LUNCH SALES Days of Week Lunch Sold Qty Unit Price Total Sold Monday Chicken 25 15.00 $ 375.00 Monday Pork 15 20.00 $ 300.00 Monday Fish 20 25.00 $ 500.00 Tuesday Mutton 15 23.00 $ 345.00 Tuesday Fish 30 25.00 $ 750.00 Wednesday Chicken 55 15.00 $ 825.00 Thursday Turkey 45 18.00 $ 810.00 Friday Turkey 60 18.00 $ 1,080.00 Saturday Chicken 15 15.00 $ 225.00 Saturday Mutton 45 23.00 $ 1,035.00 Saturday Fish 55 25.00 $ 1,375.00 Saturday Turkey 50 18.00 $ 900.00 Saturday Pork 20 20.00 $ 400.00 Sunday Fish 55 25.00 $ 1,375.00 Sunday Mutton 35 23.00 $ 805.00 Sunday Chicken 30 15.00 $ 450.00 #NAME? Fruit # of Days Sold Total Sold Sum of Total Sold Chicken Mutton Fish Turkey Pork Instructions: (Fill in the columns of the "Calculations Table") 1.…