Econ final assignment due in 3 days

profileFredq
AGEC4213_Final_2020.xlsx
Home>Business & Finance homework help>Economics homework help>Econ final assignment due in 3 days

Bonus

Employee Sales Bonus Bonus Next Bonus Next10%
Bill $ 446,127
Dill $ 724,229
Fill $ 642,837
Gill $ 364,438
Hill $ 1,269,977
Jill $ 777,809
Mill $ 572,970
Nill $ 341,342
Pill $ 1,326,151
Rill $ 1,175,821
Sill $ 875,115
Till $ 600,024
Vill $ 853,954
Will $ 1,278,960
Zill $ 875,369
Total $12,125,123.73 $0.00 $0.00 $0.00
> $400,000 sales bonus 0.50000%
>$400,000 sales bonus 0.50000%
Fill in CWID in the red cells below as shown:
If CWID = A12345678
A 123 45 678
A 123 45 678
$ 445,879 By typing my name below I am agreeing that I have not discussed this exam with anyone and all work is my own.
$ 723,981
$ 642,589
$ 364,190
$ 1,269,729
$ 777,561
$ 572,722
$ 341,094
$ 1,325,903
$ 1,175,573
$ 874,867
$ 599,776
$ 853,706
$ 1,278,712
$ 875,121

Break-even

Inputs
Grain sold 250 bu/acre
Pasture Value 10 $/acre Break-even Yield at $5.00 per bushel = bu/acre
Selling price $ 5.00 $/bu
NonHarvest VC $ 295 $/acre Break-even price at 250 bushels per acre = $/bushel
Custom Harvest $ 30 $/acre
Excess bushels $ 0.25 S/bu over ==> 200
Hauling cost $ 0.25 $/bu
Fixed costs $ 373 per acre
Tax rate 20% % of Profit before taxes
Income statement
Revenue
Grain Profit Matrix
Pasture
Total Revenue Yield per acre
180 190 200 210 220 230 240 250 260 270 280 290 300 310
Expenses $ 2.00
Nonharvest VC Selling price $ 2.25
Custom Harvest per bushel $ 2.50
Excess Bushels Cost $ 2.75
Hauling Cost $ 3.00
Fixed costs $ 3.25
Total costs $ 3.50
$ 3.75
Profit before tax $ 4.00
Tax $ 4.25
Net income $ 4.50
$ 4.75
$ 5.00
$ 5.25
$ 5.50
$ 5.75
$ 6.00
$ 6.25
$ 6.50
$ 6.75
$ 7.00

Mix

Hats Selling Price Cloth Needed units Leather Needed units Cutting Labor Hours Sewing Labor Hours Finishing Labor hours
Cloth $ 45.00 1 0 0.05 0.075 0.05
Cloth & leather $ 49.00 0.75 0.25 0.05 0.15 0.075
Leather $ 56.00 0 1 0.05 0.1 0.1
Labor Wage Rate / Hour Supply of Labor Hours Materials Material Cost / unit Supply of Material Units
Cutting $ 10.00 92.25 Cloth $ 6.78 1,250
Sewing $ 12.50 184.5 Leather $ 12.78 1,250
Finishing $ 15.00 123
Compute Values
Total Revenues
Total Costs
Profit 
Type of Hat Number Produced Units of Cloth Used Units of Leather Used Cutting Labor Used Hours Sewing Labor Used Hours Finishing Labor Used Hours
Cloth
Cloth & leather
Leather
Totals

Oats

obs Oats Nitrogen P2O5 K2O
1 46.4 0 0 0
2 42.6 0 0 0
3 43.2 0 0 0
4 42.9 0 0 0
5 52.8 0 0 0
6 48.5 0 0 0
7 44 0 0 0
8 41.3 0 0 0
9 39.2 0 0 0
10 42.6 0 0 0
11 43.2 0 40 0
12 56.3 0 40 0
13 42.7 0 80 0
14 46.5 0 80 0
15 39 0 160 0
16 44.6 0 0 40
17 44.4 0 0 40
18 45.7 0 40 40
19 49.4 0 40 40
20 56.6 0 80 40
21 52.1 0 80 40
22 51.2 0 160 40
23 41.7 0 0 80
24 41.7 0 0 80
25 54.8 0 40 80
26 49.6 0 40 80
27 53.5 0 80 80
28 47.5 0 80 80
29 47.3 0 160 80
30 40.2 0 0 160
31 37.9 0 40 160
32 46 0 80 160
33 44.2 0 160 160
34 51.5 40 0 0
35 55.5 40 0 0
36 45.2 40 40 0
37 48.8 40 40 0
38 51.5 40 80 0
39 41.7 40 80 0
40 49.4 40 160 0
41 54.6 40 0 40
42 54.1 40 0 40
43 56.8 40 40 40
44 52.4 40 40 40
45 57.5 40 80 40
46 52.4 40 80 40
47 51.1 40 160 40
48 54 40 0 80
49 52.7 40 0 80
50 44.6 40 40 80
51 48 40 40 80
52 45.7 40 80 80
53 49.1 40 80 80
54 49.3 40 160 80
55 47 40 0 160
56 41.3 40 40 160
57 45.7 40 80 160
58 49.7 40 160 160
59 40 80 0 0
60 43.3 80 0 0
61 52 80 40 0
62 45.8 80 40 0
63 57.8 80 80 0
64 59.1 80 80 0
65 56.2 80 160 0
66 42.1 80 0 40
67 42.5 80 0 40
68 48.9 80 40 40
69 59.2 80 40 40
70 53.8 80 80 40
71 58.8 80 80 40
72 52.7 80 160 40
73 61.5 80 0 80
74 53.2 80 0 80
75 59.9 80 40 80
76 56.6 80 40 80
77 51.2 80 80 80
78 51.5 80 80 80
79 52.8 80 160 80
80 48.4 80 0 160
81 55.9 80 40 160
82 49.9 80 80 160
83 46.4 80 160 160
84 47 120 0 0
85 45.3 120 40 0
86 51.1 120 80 0
87 57.5 120 160 0
88 47 120 0 40
89 49 120 40 40
90 58.1 120 80 40
91 50.5 120 160 40
92 62.2 120 0 80
93 49.1 120 40 80
94 59.7 120 80 80
95 53.2 120 160 80
96 54.3 120 0 160
97 45.7 120 40 160
98 51.5 120 80 160
99 54.1 120 160 160
100 34.5 240 0 0
101 41.1 240 40 0
102 54.1 240 80 0
103 63.1 240 160 0
104 45.5 240 0 40
105 55.2 240 40 40
106 55 240 80 40
107 61.7 240 160 40
108 54.1 240 0 80
109 52.6 240 40 80
110 53.3 240 80 80
111 62.7 240 160 80
112 55.3 240 0 160
113 56.6 240 40 160
114 52 240 80 160
115 59.2 240 160 160