BUS 241 Jubail University College Breakeven Excel Calculations Project i need answers for question 1 part B,C only part B should include the draw using exc

BUS 241 Jubail University College Breakeven Excel Calculations Project i need answers for question 1 part B,C only part B should include the draw using excel Jubail University College
Department of Business Administration
Semester 402
Assignment No: II
Section No:
Course Code: BUS 241
Course Name: Operations
Student ID
Student Name
Page 1 of 4
Assignment II
Submission on Blackboard: Wednesday (March 26, 2020), Week 10
Question 1 – 15 Marks
Question 2 – 5 Marks
Question 3 – 5 Marks
Total Mark: Out of 25 marks
Total Mark: Out of 10 marks
a. Follow the same group of assignment 1.
b. Write the formula for every question depending upon the requirement (CLO 6)
Page 2 of 4
Calculations: Answer all the THREE questions
Question 1:
A petrochemical manufacturer wants to take a decision on identifying the range of production
volume for each type of the production process. You are given the opportunity to contribute your
views in making a choice among the processors. The annual fixed and variable costs for each
process is given in the table below:
(15 Marks)
Fixed cost (in $)
Variable cost (in $) per gallon
a. The selling price of one gallon of chemical is $275. Which process would you suggest it
the demand is 5000 gallons annually? What will be the profit for this volume of demand?
(5 marks)
b. Conduct breakeven analysis and determine the range of units for each of the process (use
excel to draw the graph). (6 marks)
c. Is there any process that is not considered? If so, why? (2 mark)
d. Mention which process is suitable for the volume of production mentioned below. (2
a. 750 gallons
b. 3000 gallons
c. 25000 gallons
d. 12500 gallons
Page 3 of 4
Question 2:
An investor of a chain of retail outlets is planning to centralize their warehouse for the retail outlets that are plotted on the below graph. The investor discussed with his manager to come up
with a centralized location to setup a warehouse so that the transport cost is optimal such that
equal amount of goods are dispatched every day to these outlets.
(5 Marks)
Question 3:
How does information technology contribute in operations management? (5 marks)
Note: Not more than 200 words
Page 4 of 4

Purchase answer to see full

Don't use plagiarized sources. Get Your Custom Essay on
BUS 241 Jubail University College Breakeven Excel Calculations Project i need answers for question 1 part B,C only part B should include the draw using exc
Just from $13/Page
Order Essay
Homework Writings Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Why should I choose Homework Writings Pro as my essay writing service?

We Follow Instructions and Give Quality Papers

We are strict in following paper instructions. You are welcome to provide directions to your writer, who will follow it as a law in customizing your paper. Quality is guaranteed! Every paper is carefully checked before delivery. Our writers are professionals and always deliver the highest quality work.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Reasonable Prices and Free Unlimited Revisions

Typical student budget? No problem. Affordable rates, generous discounts - the more you order, the more you save. We reward loyalty and welcome new customers. Furthermore, if you think we missed something, please send your order for a free review. You can do this yourself by logging into your personal account or by contacting our support..

Essay Delivered On Time and 100% Money-Back-Guarantee

Your essay will arrive on time, or even before your deadline – even if you request your paper within hours. You won’t be kept waiting, so relax and work on other tasks.We also guatantee a refund in case you decide to cancel your order.

100% Original Essay and Confidentiality

Anti-plagiarism policy. The authenticity of each essay is carefully checked, resulting in truly unique works. Our collaboration is a secret kept safe with us. We only need your email address to send you a unique username and password. We never share personal customer information.

24/7 Customer Support

We recognize that people around the world use our services in different time zones, so we have a support team that is happy to help you use our service. Our writing service has a 24/7 support policy. Contact us and discover all the details that may interest you!

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our reputation for excellence in providing professional tailor-made essay writing services to students of different academic levels is the best proof of our reliability and quality of service we offer.


Essay Writing Service

When using our academic writing services, you can get help with different types of work including college essays, research articles, writing, essay writing, various academic reports, book reports and so on. Whatever your task, homeworkwritingspro.com has experienced specialists qualified enough to handle it professionally.


Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.


Editing Support

Our professional editor will check your grammar to make sure it is free from errors. You can rest assured that we will do our best to provide you with a piece of dignified academic writing. Homeworkwritingpro experts can manage any assignment in any academic field.


Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.