Figure 2.41 shows the 2016 U.S. federal income tax rates for the four different types of filing status. Suppose an individual is single. Write one logical IF function that will

26 Mar Figure 2.41 shows the 2016 U.S. federal income tax rates for the four different types of filing status. Suppose an individual is single. Write one logical IF function that will

Posted at 12:23h in Business & Finance by

HW with Business Analytics.

Qtn 21

Figure 2.41 shows the 2016 U.S. federal income tax rates for the four different types of filing status. Suppose an individual is single. Write one logical IF function that will determine the correct tax rate for any income that is entered in cell B3 of a spreadsheet. Implement this on a spreadsheet and verify its correctness

Qtn 29

Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between each pair of cities in the Excel file General Appliance Corporation, which shows the solution to an optimization model that finds the minimum cost and amounts shipped from two plants to four distribution centers. Your table should be set up as follows, and the formulas for the Amount Shipped column should reference the names in the From and To column

Qtn 37

Construct PivotTables showing the counts of gender versus carrier and type versus usage in the Excel file Cell Phone Survey. What might you conclude from this analysis?

Data

Cell Phone Survey
Gender	Carrier	Type	Usage	Signal strength	Value for the Dollar	Customer Service
M	AT&T	Smart	High	5	4	4
M	AT&T	Smart	High	5	4	2
M	AT&T	Smart	Average	4	4	4
M	AT&T	Smart	Very high	2	3	3
M	AT&T	Smart	Very high	5	5	2
M	AT&T	Smart	Very high	4	3	5
M	AT&T	Smart	Very high	3	4	4
F	AT&T	Smart	Very high	3	2	3
F	AT&T	Smart	Very high	4	3	4
M	AT&T	Smart	Very high	3	3	1
M	Other	Smart	Average	1	2	4
M	Sprint	Smart	Very high	3	5	4
M	Sprint	Smart	Very high	3	5	3
F	Sprint	Smart	Average	2	5	4
F	Sprint	Smart	Average	3	5	4
M	Verizon	Smart	Average	4	3	3
F	Verizon	Smart	Very high	4	3	2
M	Verizon	Smart	Very high	5	5	5
F	Verizon	Smart	Average	3	3	3
M	Verizon	Smart	Very high	4	4	2
F	Verizon	Smart	Very high	4	5	3
M	AT&T	Camera	Average	5	4	5
M	AT&T	Camera	Very high	2	1	3
M	AT&T	Camera	Average	2	4	3
F	AT&T	Camera	Very high	3	3	3
M	AT&T	Camera	Average	5	5	3
F	AT&T	Camera	Average	4	3	3
M	AT&T	Camera	Average	4	2	4
F	AT&T	Camera	Very high	2	4	1
F	AT&T	Camera	Average	2	4	3
M	AT&T	Camera	Average	3	3	4
F	AT&T	Camera	Very high	3	2	3
M	AT&T	Camera	Very high	4	3	3
F	AT&T	Camera	Low	4	2	3
M	Other	Camera	Average	3	3	3
F	Other	Camera	Average	2	3	3
M	Other	Camera	Average	4	3	4
M	Sprint	Camera	Average	3	4	4
F	Verizon	Camera	Very high	3	4	3
F	Verizon	Camera	Very high	4	3	1
M	AT&T	Basic	Average	3	3	3
M	AT&T	Basic	Average	3	3	2
M	AT&T	Basic	Low	3	3	3
M	Other	Basic	Average	3	3	5
M	Other	Basic	Very high	4	3	3
M	Other	Basic	Very high	1	3	4
M	Other	Basic	Low	4	4	2
F	Other	Basic	Average	2	3	3
F	T-mobile	Basic	Low	3	4	4
M	T-mobile	Basic	Average	3	4	3
M	Verizon	Basic	Low	3	3	4
M	Verizon	Basic	Average	4	2	4

Transportation Model

General Appliance Corporation
Data
	Distribution Center
Plant	Cleveland	Baltimore	Chicago	Phoenix	Capacity
Marietta	$12.60	$14.35	$11.52	$17.58	1200
Minneapolis	$9.75	$16.26	$8.11	$17.92	800
Demand	150	350	500	1000
Model
	Distribution Center
Plant	Cleveland	Baltimore	Chicago	Phoenix	Total shipped
Marietta	0	350	0	850	1200
Minneapolis	150	0	500	150	800
Demand met	150	350	500	1000
	Cost
Total	$28,171.00

Answer Report 1

Objective Cell (Min)
	Cell	Name	Original Value	Final Value
	$B$18	Total Cost	$0.00	$28,171.00
Variable Cells
	Cell	Name	Original Value	Final Value	Integer
	$B$13	Marietta Cleveland	0	0	Contin
	$C$13	Marietta Baltimore	0	350	Contin
	$D$13	Marietta Chicago	0	0	Contin
	$E$13	Marietta Phoenix	0	850	Contin
	$B$14	Minneapolis Cleveland	0	150	Contin
	$C$14	Minneapolis Baltimore	0	0	Contin
	$D$14	Minneapolis Chicago	0	500	Contin
	$E$14	Minneapolis Phoenix	0	150	Contin
Constraints
	Cell	Name	Cell Value	Formula	Status	Slack
	$B$15	Demand met Cleveland	150	$B$15=$B$8	Binding	0
	$C$15	Demand met Baltimore	350	$C$15=$C$8	Binding	0
	$D$15	Demand met Chicago	500	$D$15=$D$8	Binding	0
	$E$15	Demand met Phoenix	1000	$E$15=$E$8	Binding	0
	$F$13	Marietta Total shipped	1200	$F$13<=$F$6	Binding	0
	$F$14	Minneapolis Total shipped	800	$F$14<=$F$7	Binding	0

Sensitivity Report 1

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Variable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$B$13	Marietta Cleveland	0	3.19	12.6	1E+30	3.19
	$C$13	Marietta Baltimore	350	0	14.35	1.57	1E+30
	$D$13	Marietta Chicago	0	3.75	11.52	1E+30	3.75
	$E$13	Marietta Phoenix	850	0	17.58	0.34	1.57
	$B$14	Minneapolis Cleveland	150	0	9.75	3.19	1E+30
	$C$14	Minneapolis Baltimore	0	1.57	16.26	1E+30	1.57
	$D$14	Minneapolis Chicago	500	0	8.11	3.75	1E+30
	$E$14	Minneapolis Phoenix	150	0	17.92	1.57	0.34
Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$B$15	Demand met Cleveland	150	9.75	150	0	150
	$C$15	Demand met Baltimore	350	14.69	350	0	150
	$D$15	Demand met Chicago	500	8.11	500	0	500
	$E$15	Demand met Phoenix	1000	17.92