GRAPHICAL METHOD: A school is preparing a trip for 400 students. The company who is providing the transportation has 10 buses of 50 seats each and 8 buses of 40 seats, but only has 9 drivers available. The rental cost for a large bus is $800 and $600 for the small bus. Calculate how many buses of each type should be used for the trip for the least possible cost. Attach the PDF or JPEG file of the solution made.

GRAPHICAL METHOD: A school is preparing a trip for 400 students. The company who is providing the transportation has 10 buses of 50 seats each and 8 buses of 40 seats, but only has 9 drivers available. The rental cost for a large bus is $800 and $600 for the small bus. Calculate how many buses of each type should be used for the trip for the least possible cost. Attach the PDF or JPEG file of the solution made.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter7: Linear Regression

Section: Chapter Questions

Problem 6P: A marketing professor at Givens College is interested in the relationship between hours spent...

See similar textbooks

Similar questions

Solve. Show the system of equations used and show your work on solving the system: A company wants to advertise its product in a certain magazine. The magazine offers two ad plans: Plan A: 6 full-page ads and 6 half-page adds will cost $2550 Plan B: 8 full-page ads and 4 half-page ads will cost $2800 Find: The cost of a full-page ad b. The cost of a half-page ad a.
t.php?attempt%3D1347310&cmid3D701917&page3D2 E-learning services SQU Libraries SQU Portal Attendance English (en) Ali decided to install a new internet fiber service. He signed a contract with Company XYZ. The contract states that Ali pays a monthly subscription fee. Ali's monthly internet cost can be classified as a: t of estion Select one: a. Sunk cost b. Fixed cost C. Moderation cost O d. Mixed cost Oe. Variable cost ious page Next page - Answers to Ch3 Additional Exercises Jump to Exam 1 Part 2- Sp20
Consider the following hypothetical sales scenario. A large community college buys and takes delivery of 50 iMac computers from a local Apple store. The invoiced price is $2,800 per unit and includes hardware, software essential to the functionality of the hardware, third-party software including Microsoft Office for Mac and Adobe Creative Suite, and two years of tech service and support. Apple uses vendor-specific objective evidence to determine unit prices of $2,500 and $300 for hardware and the essential software, respectively. The third-party software typically retails for $500 (but Apple purchases it at a 50% discount) and equivalent service and support contracts are $100 per year. The customer (the community college) can opt to purchase subsequent essential software and OS upgrades. Indicate how Apple should record gross revenue for the transaction at the time the customer takes delivery of the computers. Your response should include specific dollar amounts.
You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process: Costs/Benefits College Course Community Course Cost $4,300 $1,190 Distance to course 0.20 miles (walking distance) 18 miles (driving distance) Timing of course Weekday Weekend Number of meetings 16 8 Qualitative considerations Convenience, quality of instruction Flexibility, brief duration Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose? Multiple Choice College course Community course Both alternatives Neither alternative
The Excel worksheet form that appears below is to be used to recreate the Review Problem pertaining to the Magnetic Imaging Division of Medical Diagnostics, Inc. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form. You should proceed to the requirements below only after completing your worksheet. Required: 1. Check your worksheet by changing the average operating assets in cell B6 to $8,000,000. The ROI should now be 38% arid the residual income should now be $1,000,000. If you do not get these answers, find the errors in your worksheet and correct them. Explain why the ROI and the residual income both increase when the average operating assets decrease. 2. Revise the data in your worksheet as follows: a. What is the ROI? b. What is the residual income? c. Explain the relationship between the ROI and the residual income?
Download the attached Excel file (First Q Profits Report W Goal Seek_Ver2.xlsx). Instructions: . There are 3 Worksheet Tabs in this Excel file; First Q, First Q Goal Seek, and Minivan Loan. • The First Q (First Quarter) tab shows the first quarter revenue and expenses of the Downtown Internet Cafe. For this tab, • Complete the Proportion column, cells G7 through G11 Each proportion value shows the % of the quarterly sale of that item over the entire sale. Calculate the Net Income row, cells B24 through F24. o Compute the Profit Margin row, Cells B25 through E25. o Add Net Income Sparkline for January through March in Cell H24. in For this tab
Formulate the situation as a system of two linear equations in two variables. Be sure to state clearly the meaning of your x- and y-variables. Solve the system by the elimination method. Be sure to state your final answer in terms of the original question. The concession stand at an ice hockey rink had receipts of $8200 from selling a total of 3400 sodas and hot dogs. If each soda sold for $2 and each hot dog sold for $3, how many of each were sold? X = sodas y = hot dogs
https://elearn.squ.edu.om/mod/quiz/attempt.php?attempt=1863256&cmid%3D88624 (SQU E-LEARNING SYSTEM 0:30:28 ll Sur Travel Company intends to sell its customers a special round-trip airline ticket package to Salalah. The Company will be able to purchase the package from Oman Air for OMR 150 each. The round-trip tickets will be sold for OMR 250 each and the airline intends to reimburse Sur Travel for any unsold ticket packages. Fixed costs for Sur Travel include ?OMR 5,000 in advertising costs.How many ticket packages will Sur Travel need to sell to break even packages 34 a O packages 20 .b O packages 50 .c packages 13 d For XYZ Company, how many units of their product would have to be sold to yield a target operating income of $100,000 for the financial year ending 2021
Based on the COA example in the marketing math spreadsheet, how can you purchase 1 paying customer when 1000 page views resulted in only .25 of a paying customer? a. This is an irrelevant concern. b. Because one customer purchases 2000 dollars c. The .25 person number found in the COA example result came from 1000 page views that cost 30 dollars. The cost of acquisition of a paying customer in the example was 120 dollars. This means it required 4000 page views or 4*30 dollars. Consequently, 4000 page views ($120) results in one paying customer 4*.25. d. All are true e. All are false
Assume that you are responsible for planning a banquet for your school’s accounting club. The banquet will feature a dinner, followed by a speaker. The costs associated with the banquet are as follows: Meals Beverages (coffee and tea)   Use of banquet room Speaker’s fee   $10 per person $1 per person $50 $100 Assume that 50 students will attend the banquet. If you want to break even on this event, how much do you need to charge for a ticket? Please explain your answer and how it relates to Chapter 19.
The College is planning a concert. Maximum capacity for the concert venue is 3,000. tickets will be sold for $25 per ticket. The college estimates that costs of producing the concert to be 2,500 plus the cost of the band.   Alternative A a fee of $8,000 and $5 per tickets; or Alternative B - $8.00 per ticket sold Question 1. If you expect to see 3,000 tickets, which alternative produces the highest profit?
I need help answering the questions below... 1. Using the assumptions provided in Excel Spreadsheet, what is the total number of customers generated from this advertising? 2. If Dr. Corneal’s customers spend $300 on average, what is the total revenue generated from this advertising? 3. The cost to purchase the advertising is as follows: Google Ads: $5,000 Newspapers: $3,000 Magazines: $6,000 Radio:  $1,000 Calculate the overall ROI and the ROI per advertising source. How do these number help you plan your advertising budget going forward? To answer this question, define ROI, explain how ROI is used (see your book), apply the numbers you have calculated and show how you would use these numbers for planning purposes. Note - ROI is expressed as a percent. ROI= (Revenue - Costs)/Costs