Can you answer this?

  Please show work and use excel.

Integrated Case of Hope Steel, Inc.
A Brief Profile of Hope STEEL works, inc.
Hope Steel Works, Inc. – also known to the local market as ‘Hope Steel’ – is one of the largest producers of concrete-reinforcement steel bars. It was established in December of 1964 by Mr. John Long, an industry pioneer whose work in the steel industry began in 1948, the company has built up a solid reputation for superior quality, good service, and fair prices. 
Hope Steel supplies to a wide range of construction projects. Its bars are found in low-cost housing, private residences, luxury condominiums, commercial and industrial projects, high-rise buildings, schools, hospitals, bridges, highway over-passes and viaducts, dams and power stations, tunnels, airports, seaports, aqueducts, telecommunication sites, and other public infrastructure. 
Certified under ISO-9001:2000, Hope Steel regularly sample, test and analyze its products to ensure that only superior quality reaches its customers. 
Rebar Sizes  
The standard Rebar sizes that the Company manufactures and sells are as follows: 10mm, 12mm, 16mm, 20mm, 25mm, 28mm, 32mm, and 36mm. For special orders, it can also make 40mm and 50mm bars. 
Case 1 Introduction
Over the past years, the demand for 25mm rebars have fluctuated with a seasonal pattern being observed.  Since rebars are manufactured on a “made to order” basis, the VP for Production wanted an accurate forecast for the second half of this year 2015, to enable them to plan and schedule the ordering and the storage of the raw materials needed for the production. Demand for the 25 mm rebars for last year (2014) were as follows: 
Demand for the year 2014
  
x

y
 
January

3000
 
February

3500
 
March

4800
 
April

4300
 
May

2400
 
June

2700
 
July

3500
 
August

3500
 
September

1700
 
October

2100
 
November

3200
 
December

2700
 

Based on the data above, using simple linear regression with seasonality, compute the forecasts for the months of July, August, September, October, November and December of 2015.

Case 2 Introduction
In the production of rebars, carbon steel is melted down through a furnace, is molded and elongated into very hot rods, and are then pushed through the rolling mills which determines the sizes and lengths of the bars as appropriate. 
The annual demand for Carbon steel is 40,000 pounds. Its ordering cost is $ 30.00 while it’s holding cost is 20% per unit per year of the price of Carbon Steel. Carbon steel are sold at discounted prices as follows:
   
Quantity   range

Cost   (C)
 
Less   than 2500 pounds

$   0 .20 per pound
 
2500   to 5000 pounds

$   0.19 per pound
 
5000   or more pounds

$   0.18 per pound

Which quantity should be ordered and at what cost?

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 25% with the discount code: COCONUTPlace Order
+