Expert answer:Correct My Worksheets

Solved by verified expert:Attached are worksheets that needs to be corrected. Let me know if you need more information.
variance.xlsx

sales_budget.xlsx

Unformatted Attachment Preview

Approved Peyton
Report of Budget Variance
For the Yr. Ended …
Actual
Results
Static
Budget
Variance
Direct mat. variances
Cost/price variance
495.000
528.000
33.000
Effncy-variance
528.000
4.800.000
48.000
Tot. direct mat. variance
15.000
Direct lab. variances
Cost /price variance
240.250
240.250
Effncy.- variance
240.250
232.500
Tot. direct labor variance
7.750
7.750
Favorable/
Unfavorable
F
U
U
N
U
U
Incorrect
Incorrect
Incorrect
Incorrect
Incorrect
Incorrect
Labor-variance
actual cost
$ 495.000,00
15
Price-variance
Effncny-Variance
actual qnt.
33.000
(48.000)
Labor-variance
15000
strd. Cost
$ 480.000,00
F
U
33.000
U
Good job!
Mat. variance
actual cost
$ 240.250,00
Price-variance
Effncy. Variance
Mat. variance
7,75
actual qnty.
31.000
strd. cost
$
232.500
(7.750)
N
U
7.750
U
Good job!
strd. Qnty.
16
30.000
strd. Qnty.
7,75
30.000
Sales Budget
Approved Peyton
Sales Budgets
Jul., Aug., and Sept. 2015
Units Budgeted
Jul-15
Aug-15
Sep-15
Tot. for the 1st. quarter
18.000,0
22.000,0
20.000,0
60.000,0
Prdctn. Budget
Approved P
Prodctn. Bu
Jul., Aug., and S
Next month’s budgt. sales
% of inve. to future sales
Budgtd. ending inve.
sum budgtd. sales
Req. units to be prodcd.
substrct. starting inve. (Previous
month ending inve.)
Units to be prod.
Manuf. Budget – contains raw mat. budget, direct labor budget, and fac. ov
Approved Peyton
Raw Mat. Budget
Jul., Aug., and Sept. 201
Jul.
Prodctn. budget (units)
16600,00
Mat. Reqmnt. per unit
0,50
Mat.reqrd. for prod.
8300,00
Add budgtd. ending inve.
2060,00
Tot. mat. Reqmnt. (units)
10360,00
Deduct starting inve.
4600,00
Mat. to be bought
5760,00
Mat. price @ unit
7,75
Tot. cost of direct mat. purchases
44640,00
Approved Peyton
Labor for Direct Budge
Jul., Aug., and Sept. 201
Jul.
Budgtd. Prodctn. (units)
Labor reqmnt. per unit (hours)
Tot. labor hours required
rate of Labor (per hour)
Labor dollars
16.600,00
0,50
8.300,00
16,00
132.800,00
Approved Peyton
Fact. Over-head Bdgt.
Jul., Aug., and Sept. 201
Jul.
Budgtd. Prodctn. (units)
16.600,00
Variable fac. overhead rate
1,35
Budgtd. vari. overhead
22.410,00
Fixed overhead
20.000,00
Budgtd. Tot. overhead
42.410,00
Selling Expe. Budget
Approved Peyton
Selling Expense Budget
Jul., Augt., and Sept. 2015
Jul.
Budgeted sales
commission Sales
percent
commissions Sales
expense
salaries Sales
Tot. selling expe.
Aug.
$18.000
$22.000
12%
12%
2.160
2.640
3.750
$5.910
3.750
$6.390
Gen. and Admin. Expe. Budget
Approved Peyton
Gen. and Admin. Expe. Budget
Jul., Augt., and Sept. 2015
Jul.
Salary.
Inte. On the longterm
note
Tot. expe.
Aug.
12.000,00
12.000,00
2.700,00
2.700,00
14.700,00
14.700,00
on
s
t. 2015
Unit Price
Budgeted
18,000
18,000
18,000
Tot. Dollars
Budgeted
$324.000,0
$396.000,0
$360.000,0
1.080.000,0 Correct!
Approved Peyton
Prodctn. Budget
Jul., Aug., and Sept. 2015
Jul.
Aug.
Sept.
Tot.
22.000
20.000
24.000
70%
70%
70%
15.400
14.000
16.800
46.200
18.000
22.000
20.000
60.000
33.400
36.000
36.800
106.200
16.800
15.400
14.000
46.200
16.600
20.600
22.800
60.000
ect labor budget, and fac. overhead budget
Approved Peyton
Raw Mat. Budget
66.000
Jul., Aug., and Sept. 2015
Aug.
Sept.
Tot.
20600,00
22800,00
60000,00
0,50
0,50
10300,00
11400,00
30000,00
2280,00
1980,00
6320,00
12580,00
13380,00
36320,00
2060,00
2280,00
8940,00
10520,00
11100,00
27380,00
7,75
7,75
81530,00
86025,00
Missing
Missing
212195,00 Correct!
Approved Peyton
Labor for Direct Budget
Jul., Aug., and Sept. 2015
Aug.
Sept.
Tot.
20.600,00
22.800,00
60.000,00
0,50
0,50
Missing
10.300,00
11.400,00
30.000,00
16,00
16,00
Missing
164.800,00
182.400,00
480.000,00 Correct!
Approved Peyton
Fact. Over-head Bdgt.
Jul., Aug., and Sept. 2015
Aug.
Sept.
20.600,00
22.800,00
1,35
1,35
27.810,00
30.780,00
81.000,00
20.000,00
20.000,00
60.000,00
47.810,00
50.780,00
d Peyton
nse Budget
d Sept. 2015
Sept.
Tot.
$60.000 Incorrect
$20.000
12%
2.400
$7.200 Incorrect
3.750
$6.150
$11.250
$18.450 Incorrect
on
e. Budget
t. 2015
Sept.
Tot.
12.000,00
36.000,00
2.700,00
8.100,00
14.700,00
Tot.
44.100,00 Correct!
60.000,00
Missing
141.000,00 Correct!
Tot.
Correct!
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades