Question: Excel: Put response in a single spreadsheet and Include an Answer Report STACycles manufactures bikes at factories in Albany, Syracuse, and Rochester. The bikes are

Excel: Put response in a single spreadsheet and Include an Answer Report

STACycles manufactures bikes at factories in Albany, Syracuse, and Rochester. The bikes are sent to regional distributors in Detroit, Knoxville, and Atlanta, with varying shipping costs. The company would like to find the least-cost way to meet the demands at each of the distribution centers. Detroit needs to receive 800 bikes each month, Knoxville needs 600, and Atlanta needs 200. Albany produces 850 each month, Syracuse 650, and Rochester 300. The shipping cost per unit from each pair of cities is given in the table below:

Distributor

Factory Detroit Knoxville Atlanta

Albany 8 12 10

Syracuse 10 14 9

Rochester 11 8 12

Is it possible for STACycles to meet the given demands with its available supply? What is a possible routing plan which minimizes costs, and what is the minimal cost?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

How do you prepare the following journal entries needed after the beginning balance? Global Bike, Inc. 1a (Excel) 2015 WINT ACCY 310 - Accounting Systems Due, Monday, Jan 12, 8am Estimated time to...

Guidelines: This is a 15 point, individual assignment. After completing the Blue Ray Excel Simulation (as shown in class), you will write a brief response about your experience and submit it in Bb...

How do you find cumulative percent of income 1993? 1998? 2004? ARE/ECN 115A Winter 2019 Problem Set 2: Inequality, Human Development, and Growth Models Due: February 8, 2019 Instructions: All of the...

Part A Given the following conventional cash flows, find the undiscounted payback, discount payback, net present value, IRR, MIRR, profitability index in Excel. Then, plot the NPV profile using the...

Assignment 2 - Forecasting Financial Statements and finding the additional funds needed ( SIFN ) to maloe the balance sheet balance. Put the balance sheet into a usable form in Excel Put the income...

Develop a project schedule using the WBS you have already created as the starting point. This should be completed using ProjectLibre. The project will start February of Year O, and should finish in...

Final Project Project will be a short paper featuring a simple regression on a topic of choice The purpose of the project is to enable the Learner to apply the statistical concepts learned to...

Final Project Notification This is notification of your final project for this course. Prior to starting your final project please get approve from your faculty mentor on your idea for the project....

Pick any topic you are interested in, which can be answered in the form of a simple least squares regression.It can be any topic. For example: Is there a relationship between higher abortion rates...

Your final project will be a short paper featuring a simple regression on a topic of your choosing. Using data from my company, we have the number of phone calls, per week, over the last year. Then...

Refer to Exercise 9. Assume that the mass of the rock is 288.2 g with negligible uncertainty, the initial volume of water in the cylinder is 400 0.1 mL, and the volume of water plus rock is 516 0.2...

Explain why single-tailed amphiphiles tend to form micelles whereas two-tailed amphiphiles tend to form bilayers.

Why does ASPE not require disclosure of earnings per share? Select answer from the options below It would not be meaningful for a company with few shareholders. The cost of calculating this number...

5. Identify three characteristics of the dialectical approach.

6. Explain the strengths of a dialectical approach.

4. Explain the strengths and weaknesses of each approach.