Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

We want to conduct an analysis for a wooden baseball bat manufacturer that is interested in diversifying its product line by adding more materials and

We want to conduct an analysis for a wooden baseball bat manufacturer that is interested in diversifying its product line by adding more materials and possibly upgrading the equipment. To help the manufacturer look at the different scenarios, write a program that includes the following:

Load the information from the MAT file titled BatCost.mat. This file contains the following variables:

Materials={'Ash';'Hickory';'Maple';'Pine}

Cost=[4.35 4.95 6.35 3.75]

LECost=1.25

The bats can be produced from four different materials: ash, hickory, maple and pine. The material names are stored as a cell array in the variable Materials.

The estimated material cost to produce 25 bats from each material is saved in the vector Cost. To determine the material cost per bat, the value given in Cost will need to be divided by 25.

The labor and energy cost to produce one bat is estimated in the scalar variable LECost. This cost is the same regardless of the bat material.

Using a menu, ask the user to select the material for the bat.

Ask the user to enter, as a scalar, the selling price of a single bat made from the chosen material. The material name chosen by the user do not need to appear in this statement.

Ask the user to enter, as a vector, the total number of bats the manufacturer can produce per week without an upgrade, and the number of weeks the manufacturer plans to run the bat production machinery in a year; these values are the same regardless of the type of bat produced.

Ask the user to enter a vector containing the ADDITIONAL number of bats that can be produced in a week if the equipment is upgraded, and the fixed cost for the upgrade.

The variable cost of production will be the summation of the material cost, labor cost, and energy cost and is the same for a given material regardless of upgrades.

Your program should calculate and display the following information in the Command Window:

Selling Price per bat:$##.## Total Variable Cost per bat:$##.## NO UPGRADE Producing ## MMM bats a week for ## weeks = ## total bats Profit:$##.#E## WITH UPGRADE Producing ## MMM bats a week for ## weeks = ## total bats Fixed Cost of upgrade:$##.## Profit:$##.#E## Breakeven Point:#### weeks 

Formatting notes

The # character in the output displayed will be actual numbers. The word MMM should be replaced with the actual material chosen by the user.

The number of bats per week, number of weeks per year, and total number of bats produced should be shown as integers.

The selling price per bat, total variable cost per bat, and fixed cost of the upgrade should be displayed with two decimal places.

The profit should be displayed in exponential notation with one decimal place.

The lines for profit, fixed cost, and breakeven point should display as indented by a single tab from the left margin.

There should be one blank line in the locations shown.

The breakeven point should be shown as an integer and rounded to show two significant figures.

The program should generate a proper plot for the number of weeks bats are produced on the abscissa and the revenue and total cost on the ordinate.

Cost curves for both scenarios (upgrade and no upgrade) should be shown along with the revenue curves.

The breakeven point for the upgrade scenario should be clearly indicated on the graph with a solid black vertical line.

The material name chosen by the user must appear in the title of the graph.

The legend should appear in the upper-left corner of the graph.

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

Automating Access Databases With Macros

Authors: Fish Davis

1st Edition

1797816349, 978-1797816340

More Books

Students also viewed these Databases questions