logo

Crowdly

Browser

Add to Chrome

ETF1100 - Business statistics - S2 2025

Looking for ETF1100 - Business statistics - S2 2025 test answers and solutions? Browse our comprehensive collection of verified answers for ETF1100 - Business statistics - S2 2025 at learning.monash.edu.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Selecting the Number of Warehouses: The company is now considering sustainability and environmental strategy. As part of its new initiative, it aims to reduce transportation emission by putting maximum cap on the total distance its delivery drivers travel to 1.5million miles in total. Use GoalSeek to determine the number of warehouses needed to allow the company to meet this initiative. Report the answer given by GoalSeek, to three decimal places.
View this question
Selecting the Number of Warehouses:

Use Excel Solver to solve for the optimal number of warehouses, given that the delivery cost per mile is $1. Give the optimal Solver solution to 3 decimal places.
View this question

What is the total cost (in dollars) at this optimal number of warehouses?

View this question
Construct the data table to calculate the total cost for the number of warehouses ranging from 1 to 30. Make sure you put the number of warehouse, k, as the column variable. Input the variable delivery cost per mile as the row variable. From the data table, what is the number of warehouses that generate the smallest total costs?
View this question
Assume that the company currently operates five warehouses. What is the total distance (in miles) of delivery needed to cover the company’s customer base?
View this question

How

many units should the business produce for the “Creamy” category?

View this question

In

setting up your Excel Solver to solve this problem, which cell(s) would you

need to put “Constraints” on?

0%
0%
0%
0%
0%
0%
View this question

In setting up your Excel Solver to solve this problem, which cell(s) would

you put as the “Changing Variable Cells”?

0%
0%
0%
0%
0%
0%
View this question

How

many units should the business produce for the “Crunchy” category?

View this question

In setting up your Excel Solver to

solve this problem, which cell is the Objective cell?

100%
0%
0%
0%
0%
0%
View this question

Want instant access to all verified answers on learning.monash.edu?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome

TelegramInstagramTikTokQuestion Bank
Terms of UseContact Us