Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

OntarioTech UNIVERSITY Faculty of Business and Information Technology Assignment 2 value: 7%. Due: oct. 20th @ 11:59 PM This assignment should be completed individually.

image text in transcribed

OntarioTech UNIVERSITY Faculty of Business and Information Technology Assignment 2 value: 7%. Due: oct. 20th @ 11:59 PM This assignment should be completed individually. We take academic integrity seriously. Any student found to be involved in plagiarism or cheating will be penalized in accordance to the UOIT Calendar Section 5.15. To assert that you have not given or received, or used unauthorized assistance, write the following pledge in the comment textbox when you submit your files through Blackboard system. "I have nor given, received, or used any unauthorized assistance. " I. Flight Schedule (30 Points) Data File needed for this exercise: None Suppose that a technology company has 12 sales representatives based in New York City and 18 sales representatives based in San Francisco. To staff an upcoming trade show in Dallas and another trade show in Chicago, the company wants to send at least 15 sales representatives to Dallas and at least I O sales representatives to Chicago. Also, at least 5 ofthe sales representatives in San Francisco must be sent to Dallas. According to expedia.com, for October 2021, the lowest non-stop round-trip airfares (including taxes and fees in USD) for a one-week stay, with tickets purchased two weeks m advance, are as follows: San Francisco to Dallas: SI 13; San Francisco to Chicago: S377; New York (LaGuardia) to Dallas: S 142; New York (LaGuardia) to Chicago: S 170. Using Excel Solver, determine how many sales representatives this company should send from New York City to each trade show and how many should be sent from San Francisco to each trade show in order to satisfy the staffing requirements while minimizing the total airfare required to send the representatives. Be sure to select keep the Solver solution and generate answer report. Excel Solver Your task is to use Excel Solver and determine how many sales representatives this company should send from New York City to each trade show and from San Francisco to each trade show in order to satisfy the staffing requirements while minimizing the total airfare required to send the representatives. Be sure to select keep the Solver solution and generate answer report. (a) Open a NEW workbook and save it as Flight Schedule.xlsx. Insert a Documentation worksheet and add appropriate title for the workbook in cell A I. In cell B3 enter your name. In cell B4 enter your student number. In cell B5 enter the completion date of your assignment and in cell B6 enter a sentence to describe the purpose of the workbook. (b) Using a new worksheet, formulate and enter the above flight problem. Note: you can find several examples on Excel Solver on Canvas under Module Lecture 4.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: Marshall RomneyPaul Steinbart

11th Edition

136015182, 978-0136015185

More Books

Students also viewed these Accounting questions

Question

Show that.AppendixLO1 1Vx = 1 - (1-1Vx)(1-1Vx+1)(1-1Vx+1-1).

Answered: 1 week ago

Question

1. Information that is currently accessible (recognition).

Answered: 1 week ago