these are worksheets busn201 class

Ch14Hmwksend.xlsxCopy of Ch13Hmwk Data.xlsxchp12LO.xlsxchpt14docsend.docx
ch14hmwksend.xlsx

ch14hmwksend.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
these are worksheets busn201 class
Just from $13/Page
Order Essay

chpt14docsend.docx

copy_of_ch13hmwk_data.xlsx

chp12lo.xlsx

Unformatted Attachment Preview

Part AB500
Gross Requirements
Scheduled Receipts
Projected Advantageous
Planned Classifys
1
2
3
4
5
6
7
8
9
10
Part AB501
Gross Requirements
Scheduled Receipts
Projected Advantageous
Planned Classifys
1
2
3
4
5
6
7
8
9
10
Part AB511
Gross Requirements
Scheduled Receipts
Projected Advantageous
Planned Classifys
1
2
3
4
5
6
7
8
9
10
Part AB521
Gross Requirements
Scheduled Receipts
Projected Advantageous
Planned Classifys
1
2
3
4
5
6
7
8
9
10
Machines
Work spell
Word days
Effic Scold
Util Scold
Advantageous Capacity
Added Capacity
3
8
5
90%
90%
Orders
LL110
LL118
LL131
LL140
Qty
10
25
100
50
Setup Spell
2.0
4.0
6.0
4.0
Run Spell
1.2
0.4
0.6
0.2
Hrs Needed
Machines
Work spell
Word days
Effic Scold
Util Scold
Advantageous Capacity
Added Capacity
3
15
5
80%
90%
Orders
LL110
LL118
LL131
LL140
Qty
10
25
100
55
Setup Spell
2.5
4.5
6.5
4.5
Run Spell
1.2
0.4
0.7
0.1
Hrs Needed
Machines
Work spell
Word days
Effic Scold
Util Scold
Advantageous Capacity
Added Capacity
3
12
6
Orders
LL110
LL118
LL131
LL140
Orders
LL110
LL118
LL131
LL140
Qty
100
250
100
500
Qty
100
250
100
500
Setup Spell
4.0
6.0
3.0
8.0
Setup Spell
4.0
6.0
3.0
8.0
Run Spell
0.3
0.1
0.3
0.1
Run Spell
0.3
0.1
0.3
0.1
Hrs Needed
Hours
Needed
Part AB500
Gross Requirements
Scheduled Receipts
Projected Advantageous
Planned Classifys
1
2
3
4
5
6
7
8
9
10
Part AB501
Gross Requirements
Scheduled Receipts
Projected Advantageous
Planned Classifys
1
2
3
4
5
6
7
8
9
10
Part AB511
Gross Requirements
Scheduled Receipts
Projected Advantageous
Planned Classifys
1
2
3
4
5
6
7
8
9
10
Part AB521
Gross Requirements
Scheduled Receipts
Projected Advantageous
Planned Classifys
1
2
3
4
5
6
7
8
9
10
Machines
Work spell
Word days
Effic Scold
Util Scold
Advantageous Capacity
Added Capacity
3
8
5
90%
90%
Orders
LL110
LL118
LL131
LL140
Qty
10
25
100
50
Setup Spell
2.0
4.0
6.0
4.0
Run Spell
1.2
0.4
0.6
0.2
Hrs Needed
Machines
Work spell
Word days
Effic Scold
Util Scold
Advantageous Capacity
Added Capacity
3
15
5
80%
90%
Orders
LL110
LL118
LL131
LL140
Qty
10
25
100
55
Setup Spell
2.5
4.5
6.5
4.5
Run Spell
1.2
0.4
0.7
0.1
Hrs Needed
Machines
Work spell
Word days
Effic Scold
Util Scold
Advantageous Capacity
Added Capacity
3
12
6
Orders
LL110
LL118
LL131
LL140
Orders
LL110
LL118
LL131
LL140
Qty
100
250
100
500
Qty
100
250
100
500
Setup Spell
4.0
6.0
3.0
8.0
Setup Spell
4.0
6.0
3.0
8.0
Run Spell
0.3
0.1
0.3
0.1
Run Spell
0.3
0.1
0.3
0.1
Hrs Needed
Hours
Needed
Problem
Consume data
Regular-spell strive consume per hour
Overspell strive consume per hour
Subcontracting consume per individual (strive solely)
Pursuit consume per individual per age
Back-classify consume per individual per age
Hiring consume per employee
Firing consume per employee
Capacity data
Beginning workforce
Beginning flatten
Strive measure per individual
Regular-spell advantageous per age
Overspell advantageous per age
Subcontracting utmost per age
Subcontracting poverty per age
Call-coercion data
Age 1
Age 2
Age 3
Age 4
Age 5
Age 6
2
$10.00
$15.00
$84.00
$10.00
$20.00
$600.00
$450.00
210
400
6
160
32
1000
500
6000
4800
7840
5200
6560
3600
Use board 13-12
Period
Demand
Cumulative Call-for
Cum Dem/#Periods
Age Production
Cum Production
Ending Flatten
Number of employees
Number to hire
Number to fire
employees
units
hrs
26.66667
hours
4 wks
Costs of Plan
hrs
Represent spell strive
units
Pursuit consumes
units
Hiring
Sum consumes
units
units
Consume per individual
units
units
units
units
1
2
3
4
5
6
Total
0
use the max of the line aloft.
Behold page 506 coercion model
page 478
$0.00
use the max of the line aloft.
Problem
CHASE PLAN
Consume data
Regular-spell strive consume per hour
Overspell strive consume per hour
Subcontracting consume per individual (strive solely)
Pursuit consume per individual per age
Back-classify consume per individual per age
Hiring consume per employee
Firing consume per employee
Capacity data
Beginning workforce
Beginning flatten
Strive measure per individual
Regular-spell advantageous per age
Overspell advantageous per age
Subcontracting utmost per age
Subcontracting poverty per age
Call-coercion data
Age 1
Age 2
Age 3
Age 4
Age 5
Age 6
3
$10.00
$15.00
$84.00
$10.00
$20.00
$600.00
$450.00
210
400
6
160
32
1000
500
6000
4800
7840
5200
6560
3600
employees
units
hrs
27
hours
4 wks
hrs
units
units
units
units
units
units
units
units
Use board 13-12
Period
Call-coercion (enmesh of beseech flatten)
Production per age
Employees needed in age
Number to hire
Number to fire
Costs of Plan
Represent spell strive
Hiring Consume
Firing Consumes
Sum consumes
Consume per individual
1
5,600
2
4,800
3
7,840
4
5,200
5
6,560
6
3,600
= sum employees needed X represent hours per age X strive consume per ho
= sum compensated X hiring consume per employee
= sum fired X firing consume per employee
Total
33,600
=F4
=F5/D14
=MAX(B12-F7,0)
=MAX(F7-B12,0)
r age X strive consume per hour
Problem
DRAPER TAX COMPANY
8
Consume data
Regular-spell strive consume per hour
Overspell strive consume per hour
Tempory worker consume per hour
Hiring consume per employee
Firing consume per employee
Backclassify Consume
Use board 13-12
Period
Demand
Cumulative Call-for
Cum Dem/#Periods
Age Production
Cum Production
Ending Flatten
$25.00
$37.50
$40.00
$2,000.00
$1,200.00
$500.00
Capacity data
Beginning workforce
Strive measure per individual
Regular-spell advantageous per age
Overspell advantageous per age
Call-coercion data
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
12
12
40
8
48
36
50
40
38
48
employees
hrs
hours
hrs
clients
clients
clients
clients
clients
clients
Number of employees
Number to hire
Number to fire
1
2
3
4
5
6
Total
Problem
DRAPER TAX COMPANY
10
(NO BACKLOG)
Consume data
Regular-spell strive consume per hour
Overspell strive consume per hour
Tempory worker consume per hour
Hiring consume per employee
Firing consume per employee
Backclassify Consume
$25.00
$37.50
$40.00
$2,000.00
$1,200.00
$500.00
Capacity data
Beginning workforce
Strive measure per individual
Regular-spell advantageous per age
Overspell advantageous per age
Call-coercion data
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
12
12
40
8
48
36
50
40
38
48
employees
hrs
hours
hrs
clients
clients
clients
clients
clients
clients
(CHASE AGGERATE PLAN)
Use board 13-12
(CHASE AGGERATE PLAN)
Period
Demand
Hours required
Hours advantageous
Overspell Hours
Underspell Hours
Number of employees
Costs of Plan
Represent spell strive
Overspell consumes
Sum consumes
Consume per individual
1
2
3
4
5
6
Total
Yasuko’s Skill Emporium (YAE) ships skill from its studio located in the Far East to its division core located on the West Coast of the Individualed States. YAE
via transoceanic ship merchandise utility (15 days transit) or by motive merchandise (2 days transit spell). YAE ships 18,000 pieces of skill every-year.
Motive Merchandise
Time
Demand
Avg Tran Inv (ATI)
2
18,000
Merchandise Serv
15
18,000
ATI =
What added knowledge would be needed to compel a similitude?
tD
365
Coast of the Individualed States. YAE can transmit the skill either
nnually.
Frederick’s Farm Factory (FFF) presently maintains an mean flatten appraised at $3,400,000. The sodality estimates its cap
percent, its storage consumes at 4.5 percent, and its abandon consume at 10 percent. Investigate the annual pursuit consume scold coercion FFF and the
FFF.
Rate
Pursuit Consume
3,400,000.00
Excellent Consume
10.0%
Storage Consume
4.5%
Abandon Consume
10.0%
Pursuit Consume
e sodality estimates its excellent consume at 10
ng consume scold coercion FFF and the pursuit consumes coercion
A national insertation, Greens, uses 1560 bags of insert prop every-year. It consumes $10 to attribute an classify coercion insert prop. In an attempt to weaken its inven
Grower, the supplier of insert prop coercion Green, is donation Greens brace added charge breaks to opine. If the insertation classifys a three mon
consume per bag is $16. If Green classifys a six month minister, the consume per bag is $14.50. Greens estimates its pursuit consume to be 25 percent of th
Determine the most consume powerful classifying cunning coercion Greens.
Demand
Ordering consume
Individual Charge
Pursuit scold
EOQ
Sum Consumes
Months
Months
3
6
1560
1560
$
10.00 $
10.00
$
14.50 $
16.00
25%
25%
=SQRT(2*B11*B12/(B14*B13))
od. In an attempt to weaken its flatten Rapid
If the insertation classifys a three month minister, the
pursuit consume to be 25 percent of the individual charge.
Sam’s Auto Ammunition utilitys and repairs a point mark of coercioneign automobile. Sam uses levigate depurates throughout the year. The ammunition operates
weeks per year and weekly call-coercion is 150 depurates. Sam estimates that it consumes $20 to attribute an classify and his annual pursuit consume scold is $3 p
Currently, Sam classifys in quantities of 650 depurates. Investigate the sum annual consumes associated with Sam’s present classifying cunning.
Annual
Call-coercion (D)
Ordering consume (S) $
Pursuit consumes (H) $
Quantity (Q)
Sum Consumes
20.00
3.00
650
e year. The ammunition operates fifty-two
al pursuit consume scold is $3 per levigate depurate.
rdering cunning.
The national Duty of Tourism sells memory registers. Sue, the ruler of the duty, needs to classify these registers in walk of the main tou
seasons, Sue has unshaken the likelihood of selling contrariant quantities of the registers coercion a point wayfarer opportunity. The Duty of To
each. The registers consume Sue $5 each. The salvage appraise is estimated to be $.50 per unsold register. Determine how abundant registers Sue
expected produce.
Price
Cost
Salvage Appraise
Ordered
75000
80000
85000
90000
95000
$
$
$
12.95
5.00
0.50
75000
0.15
80000
0.25
Demand
85000
0.30
90000
0.20
95000
0.10
Expected Profit
rs in walk of the main wayfarer opportunity. Based on past
urist opportunity. The Duty of Tourism sells registers coercion $12.95
mine how abundant registers Sue should classify to maximize
=$A$13*($B$7-$B$8)
=(B$11*($B$7-$B$8))-(($A14-B$11)*($B$8-$B$9))
Given the forthcoming flatten of parts, investigate the annual custom consumes of each part. Classify each part as A, B, or C.
Item
101
102
103
104
105
201
202
203
204
205
Annual
Demand
500
1,500
5,000
250
1,500
10,000
1,000
1,500
500
100
Ordering
Cost
$
10
$
10
$
25
$
15
$
35
$
$
25
10
$
20
$
$
40
10
Holding
Cost
20%
30%
30%
25%
35%
15%
20%
25%
25%
15%
Individual Charge
$
0.50
$
0.20
$
1.00
$
4.50
$
1.20
$
0.75
$
1.35
$
0.20
$
0.80
$
2.50
Total
Annual
Percentage of
Custom Consume
Total
Classification
$
250
$
300
$
5,000
$
1,125
$
1,800
$
7,500
$
1,350
$
300
$
400
$
250
B, or C.
Classification Board
0%
C
5%
B
25%
A
Tax Preparers, Inc. works 250 days per year. The sodality uses adding deed tape at a scold of view flattens per day. Custom is believed to
be normally arranged with a measure disconnection of three flattens during manage spell. The consume of classifying the tape is $10 and pursuit consumes
are $0.30 per flatten per year. Manage spell is brace days.
Find z
Demand/day (d)
Sum Call-coercion (D)
Manage spell
Ordering consume
Pursuit consumes
EOQ
RR(97%)
SS(97%)
RR(99%)
SS(99%)
0.9700
0.9900
1.880794
2.326348
8
?? = ?? ??
2
$ 10.00
$ 0.30
?? = ??

ay. Custom is believed to
$10 and pursuit consumes

Purchase confutation to behold full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP