Question Details

(Solved) General Guidelines: Please use the sheets provided to create your answers as needed, these are your workseets to derive your answers. I will review...


Can anyone help me with this? Download both files the instructions are within.

General Guidelines:
Please use the sheets provided to create your answers as needed,
these are your workseets to derive your answers. I will review your
formulas on these sheets if I have a question about your answers.
You may add worksheets, columns and data as necessary. Please
list any assumptions you make in answering the questions. It will
help with partial credit. Grade
Q1 (2) 0 /10 Q2 0 /10 Q3 (4) 0 /15 Q4 (3) 0 /15 Q1: I bought a house in 2001. The price of the house was $200,000. I paid up front a down payment of $10,000. A loan w
for 30-year, 3.9% APR loan. Again, after 5 years, I refinanced it with 10-year, 2.9% APR. It should be all paid in 2021.
(1) Construct a Morgae Calculator to find our what would be the payments in each loan, how much of that would be for i
(2) Total the interest payment for each loan, get grand total of interest payments
payments.(Calculate grand total in M141). (5 point Mortgage Calculator - Loan #1
Mortgage Amount
Duration in Yrs
Payments/yr
Interest Rate/yr
FV
Periodic Payment $ $ Mortgage Calculator - Loan #2
200,000
30
12
7.90%
- Remaining
Principal Period Number
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 Mortgage Amount
Duration in Yrs
Payments/yr
Interest Rate/yr
FV
Periodic Payment
Interest
Payment Principal
Payment Period Number
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Remaining Principal
Total 39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Remaining Principal
Total wn payment of $10,000. A loan was provided by a bank with 7.9% APR for 30-year loan. After 5 years, I refinance it with remaining princ
should be all paid in 2021.
how much of that would be for interest and how much would be principal payment. (5 points)
ate grand total in M141). (5 points) Calculator - Loan #2
$ $ Mortgage Calculator - Loan #3 30
12
3.90%
- Remaining
Principal Mortgage Amount
Duration in Yrs
Payments/yr
Interest Rate/yr
FV
Periodic Payment
Interest
Payment Principal
Payment $ $ 10
12
2.90%
- Remaining
Principal Period Number
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 Interest
Payment 39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95 96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
Remaining Principal
0
Total
Grand Total (answer Q1(2)) ce it with remaining principal Principal
Payment Q2: Import text data from MIS INC Sales Data
Construct a pivot table to show how many to
should appear in a separate worksheet (shee
sales person into I10. (5 points) Q2 Answer ata from MIS INC Sales Data.csv file downloaded from Blackboard (copied into the box on the left). (5 points)
able to show how many total units were sold in each of the three districts by each of the salespeople (pivot table
a separate worksheet (sheet 1) left of this worksheet. Find who has the most sales in district 1. Copy the last name of the
10. (5 points) able
ame of the Power Blocks Purchasing Plan Power Blocks Urban Adventure Set
Turbo Action Kit
Power Blocks Outdoor Kit
Camping Kit Number
Purchas
ed
5000
1000
2500
1200
9700 Retail
Price
$ 19.95
$ 14.95
$ 16.95
$ 11.95 Gross
Revenue
$ 99,750.00
$ 14,950.00
$ 42,375.00
$ 14,340.00 Unit Cost
$ 15.36
$ 14.21
$ 13.77
$ 10.03 Total Unit
Cost
$ 76,800.00
$ 14,210.00
$ 34,425.00
$ 12,036.00 Q3: Brightstar Toy company is promoting its product: Power Blocks toy series. As a marketing director, you are to compar
different marketing strategies.
(1) Apply appropriate names to cells B4:C7 (2 points)
(2) Using the Scenario Table below, create scenarios for promoting "Adventure Set," "Turbo Kit," and "Camping Kit." (5 po
(3) Generate Senario Summary Report (on a separate workshe). (3 points)
(4) Which scenario is most profitable? Write answer in the cell F20 as either "Set," "Turbo," or "Camping" (5 points) Set
Num. Set
Num Turbo Kit
Num Outdoor kit
Num Camping Kit
Price Set
Price Turbo
Price Outdoor
Pricec Camping $
$
$
$ Turbo
Camping
5000
4000
4000
1000
3000
1000
2500
2500
3000
1200
1200
2000
19.95 $ 24.95 $
24.95
14.95 $ 12.95 $
14.95
16.95
### $
14.95
11.95
### $
9.95 Storage
Cost per
Unit
$ 0.15
$ 0.10
$ 0.25
$ 0.15 Total
Storage
Cost
$ 750.00
$ 100.00
$ 625.00
$ 180.00
Total Total Cost
$ 77,550.00
$ 14,310.00
$ 35,050.00
$ 12,216.00
$ 139,126.00 keting director, you are to compare scenarios of rbo Kit," and "Camping Kit." (5 points) bo," or "Camping" (5 points) Profit
$ 22,200.00
$
640.00
$ 7,325.00
$ 2,124.00
$ 32,289.00 Products
Product A
Product B Constraints
(G6) Total Cost
(E3+F3) Product A Quantity
(E4+F4) Product B Quantity
(E3*B3 + E4*B4) Total Labor in Country X
(F3*B3 + F4*B4) Total Labor in Country Y
(E3:F4) Quantity Produced Labor
Labor (manCost in Number
hour) needed to Labor Cost Country Produced in
produce one unit in Country X Y
Country X
10.00
7.50
10.00
1.00
20.00
7.50
10.00
1.00
30.00
15.00
20.00
2.00 <=
>=
>=
<=
<=
int $ 10,000.00
150
150
4500
7500
Integer Labor Cost in each Countr
man-hour Q4: MIS INC has two overseas production plants. Both countries (X and Y) have facilities to produce Products A and B.
(1) Create a Solver to maximize the total number of production (H5) with all constraints in (5 points).
(2) Run the Solver and show Answer sheet in a separate worksheet (5 points).
(3) Why do you think Product B is produced in one country and not the other? (Type the answer in cell I15) (5 points). Number
Produced in
Product
Country Y
Total Cost
Quantity
1.00 $
17.50
2
1.00 $
17.50
2
2.00 $
35.00
4 Labor Cost in each Country (per hour)
Country X
Country Y
$
7.50 $
10.00 duce Products A and B.
oints). er in cell I15) (5 points).

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200169781.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now