Search
Courses
Google Page Rank
PageRank Checker
Preview on Feedage: striving-to-build-the-catgmat-genie-in-u Add to My Yahoo! Add to Google! iPing-it Add to Feedage RSS Alerts Add To Fwicki
Feedage Grade A rated

You have just been promoted at the BBB Company and now have the responsibility of the employee orientation program Answer

You have just been promoted at the BBB Company and now have the responsibility of the employee orientation program. What components should be covered in the program? Explain what would be covered in your employee orientation program.

Ans:

Employee orientation program covers the activities involved in introducing a new employee to the organization and to the individuals to his or her work unit. The employee orientation program at the BBB company should cover the following components: – It should familiarize the new member with the organization’s objectives, history, philosophy, procedures, and rules; – Should communicate relevant HRM policies such as work hours, pay procedures, overtime requirements, and company benefits; – It should review the specific duties and responsibilities of the new member’s job; – Provide a tour of the organization’s physical facilities and introduce the employee to his or her manager and co-workers. – New employees should be exposed to organization’s culture. An employee who has been properly socialized to the organization’s culture has learned how work is done and which work-related behaviors are or are not acceptable and desirable. – HRM must provide new employees with inputs on various employee benefits programs such as choice of health insurance, setting up direct deposit of paychecks, and tax-withholding information. – HRM must spend some orientation time addressing what assistance it can offer to employees in the future such as career guidance, benefit administration, or employee training. New employee orientation is valuable to the organization, because it not only helps to socialize the new employees and get them up to speed more quickly regarding their duties and responsibilities, it also provides them with the necessary information to understand the expectations of the organization. This occurs through presentations as well as documentation, such as employee handbooks. Additionally, the organization is better protected from frivolous lawsuits by disgruntled employees, because new employees are required to sign documents indicating that they understand company rules and regulations. Additionally, the employees are able to reduce their stress levels by having their questions answered and important benefit papers completed. Frequently, the new employee receives a corporate level orientation and then a secondary level orientation at the unit level helping them to become socialized to the work group and more productive in a more rapid time frame. Most organizations recoup their investment in new employee orientation in a very short time by increased employee satisfaction as well as better employee productivity.

PROJ 598 Contracts and Procurement Week 5 Negotiation Exercise any negotiation that you have been involved in Answer

PROJ 598 Contracts and Procurement Week 5 Negotiation Exercise_Answer

Negotiation Exercise
Write a three- to five-page paper about any negotiation that you have been involved in. For this assignment, discuss a negotiation that did not result in the best possible solution for all parties. This negotiation can relate to a work experience, a family or friend experience, or any other experience where you were an active member of a negotiation.
Discuss how the negotiation experience actually happened, then consider the negotiating techniques that you have learned about in the past 4 weeks of class, and then offer an explanation of how you could have conducted the negotiation better. Explain where your new learning from the course might have been helpful in this previous negotiation.
Deliverable: A three- to five-page paper outlining your response to the above assignment

For getting the instant digital download solution, Please click on the “PURCHASE” link below to get PROJ 598 Contracts and Procurement Week 5 Negotiation Exercise_Answer

Please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

word_icon[1]

Ken, grateful that Letisha performed life-saving CPR on him after he had suffered a heart attack Answer

1. Ken, grateful that Letisha performed life-saving CPR on him after he had suffered a heart attack, writes a document with the following language: “In consideration of Letisha Washington having saved my life, I hereby promise to pay her $250 per week for life. Signed [Ken Smith].” For the next 3 years, he faithfully makes the weekly payments, and then stops. Letisha, upset that Ken broke his word to her, sues him seeking to reinstate the payments. Was there a valid contract formed in this instance? Why or why not? (5 points)

 2. Imagine that Alexandra promises to give Rasputin $1000 if he stops drinking alcohol for one week. If Rasputin does so, is a contract formed (can he enforce Alexandra’s promise to pay him $1000)? (5 points)

 3. Sami walks into a restaurant. She is given a menu, which indicates that lobster is $30. Sami orders the lobster. It arrives, and Sami thinks it is very tasty. When the bill arrives, Sami tries to execute a clever ploy she learned about in her business law class. She writes a check to the restaurant for $20, and writes “full settlement” across the top. The waiter accepts the check without looking at it, and the restaurant manager later deposits it in the restaurant’s bank account. Is this a liquidated or an unliquidated debt? Is Sami off the hook for the last $10? (5 points)

 

For getting the instant download solution, Please click on the “PURCHASE” link below to get “Ken, grateful that Letisha performed life-saving CPR on him after he had suffered a heart attack  Answer“.

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

 

Week 2 You Decide Summary Sunshine Machine Works has expanded its infrastructure Answer

Week 2 You Decide Transcript

Week 2 You Decide Summary Sunshine Machine Works has expanded its infrastructure. When they started there were just three computers, and ten employees. Now there are over 100 employees and their network will have fifty computer terminals, with two servers. During the expansion there has been a lot of discussion about the need for a written computer use policy. Your Role You are the IT Services manager for Sunshine Machine Works. This company has seen rapid growth. Management is looking to you to provide a critical input for an Information Systems Use Security Policy. Although they have a format they can use for the policy, they are looking to you to provide some guidance on areas they will need to address when creating this policy. Activity Write a paper of 500-1,000 words (double-spaced) about your experience in the Week 1 You Decide exercise. Briefly explain some of the issues that a company may face as it experiences growth and begins to address the proper use of its information systems. See Appendix C of the textbook for examples of policies which address issues companies may face. Since you are responsible for IT Services and want to keep the systems and network functioning effectively, you will want to identify activities which would be permitted and which activities would be prohibited. Management will take your policy suggestions, finalize the policy and it will be provided to the employees. Follow the instructions provided in the You Decide Exercise: Information Systems Use Security Policy.Key players Wilma Stone, Chief Executive Officer When we first started this company there were only a few computers that we used to share our files. Now, with the growth of our company we have a situation where we need to centralize our file storage. I am concerned that if we are not careful, some proprietary information could be compromised. We need a good information systems use policy in place. Keep in mind that I am also looking at expanding our business into some oil field work and the standards we will be required to comply with dictate that we have a written policy in place. Margie Nelson, Chief Financial Officer There are a lot of spreadsheets which have our account information on them. There is restricted access so that the only ones to access those files are the CEO, the General Manager, and me. No other employees have access to most of them. When they need access to financial data, I am contacted and provide them with the feedback they request. I hope that we are able to keep this system running efficiently and any policy helps enhance the safeguarding of our financial data. Gary Thomas, General Manager I look at the way we need to do business now, which entails a lot of online collaboration with our vendors, customers, and activities related to our potential sales outreach. I need to have our staff utilize our computing resources with maximum efficiency; however, I want to balance this with the realization our staff may need to check their personal email accounts, bank information, etc. As our file server has arrived and all file storage has been centralized, we need to look at how we secure our network while keeping productivity up.

Activity: Write a paper of 500-1,000 words (double-spaced) about your experience in the Week 1 You Decide exercise. Briefly explain some of the issues that a company
may face as it experiences growth and begins to address the proper use of its information systems. See Appendix C of the textbook for examples of policies which address issues
companies may face. Since you are responsible for IT Services and want to keep the systems and network functioning effectively, you will want to identify activities which would be permitted and which activities would be prohibited. Management will take your policy suggestions, finalize the policy and it will be provided to the employees.

 

For instant digital download of the above solution, Please click on the “PURCHASE” link below to get the tutorial for Week 2 You Decide Summary Sunshine Machine Works has expanded its infrastructure

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

 

Liquidity ratios. Edison, Stagg, and Thornton have the following financial information at the close of business on July 10 Answer

Edison, Stagg, and Thornton have the following financial information_Answer

Week Five Exercise Assignment
Financial Ratios

1. Liquidity ratios. Edison, Stagg, and Thornton have the following financial information at the close of business on July 10:

Edison Stagg Thornton
Cash $6,000 $5,000 $4,000
Short-term investments 3,000 2,500 2,000
Accounts receivable 2,000 2,500 3,000
Inventory 1,000 2,500 4,000
Prepaid expenses 800 800 800
Accounts payable 200 200 200
Notes payable: short-term 3,100 3,100 3,100
Accrued payables 300 300 300
Long-term liabilities 3,800 3,800 3,800

a. Compute the current and quick ratios for each of the three companies. (Round calculations to two decimal places.) Which firm is the most liquid? Why?

2. Computation and evaluation of activity ratios. The following data relate to Alaska Products, Inc:

20X5 20X4
Net credit sales $832,000 $760,000
Cost of goods sold 530,000 400,000
Cash, Dec. 31 125,000 110,000
Average Accounts receivable 205,000 156,000
Average Inventory 70,000 50,000
Accounts payable, Dec. 31 115,000 108,000

Instructions
a. Compute the accounts receivable and inventory turnover ratios for 20X5. Alaska rounds all calculations to two decimal places.

3. Profitability ratios, trading on the equity. Digital Relay has both preferred and common stock outstanding. The com¬pany reported the following information for 20X7:

Net sales $1,750,000
Interest expense 120,000
Income tax expense 80,000
Preferred dividends 25,000
Net income 130,000
Average assets 1,200,000
Average common stockholders’ equity 500,000

a. Compute the profit margin on sales ratio, the return on equity and the return on assets, rounding calculations to two decimal places.
b. Does the firm have positive or negative financial leverage? Briefly ex¬plain.

4. Horizontal analysis. Mary Lynn Corporation has been operating for several years. Selected data from the 20X1 and 20X2 financial statements follow.

20X2 20X1
Current Assets $86,000 $80,000
Property, Plant, and Equipment (net) 99,000 90,000
Intangibles 25,000 50,000
Current Liabilities 40,800 48,000
Long-Term Liabilities 153,000 160,000
Stockholders’ Equity 16,200 12,000
Net Sales 500,000 500,000
Cost of Goods Sold 322,500 350,000
Operating Expenses 93,500 85,000

a. Prepare a horizontal analysis for 20X1 and 20X2. Briefly comment on the results of your work.

5.Vertical analysis. Mary Lynn Corporation has been operating for several years. Selected data from the 20X1 and 20X2 financial statements follow.

20X2 20X1
Current Assets $86,000 $80,000
Property, Plant, and Equipment (net) 99,000 80,000
Intangibles 25,000 50,000
Current Liabilities 40,800 48,000
Long-Term Liabilities 153,000 150,000
Stockholders’ Equity 16,200 12,000
Net Sales 500,000 500,000
Cost of Goods Sold 322,500 350,000
Operating Expenses 93,500 85,000

a. Prepare a vertical analysis for 20X1 and 20X2. Briefly comment on the results of your work.

6. Ratio computation. The financial statements of the Lone Pine Company follow.

LONE PINE COMPANY
Comparative Balance Sheets
December 31, 20X2 and 20X1 ($000 Omitted)
20X2 20X1
Assets
Current Assets
Cash and Short-Term Investments $400 $600
Accounts Receivable (net) 3,000 2,400
Inventories 3,000 2,300
Total Current Assets $6,400 $5,300
Property, Plant, and Equipment
Land $1,700 $500
Buildings and Equipment (net) 1,500 1,000
Total Property, Plant, and Equipment $3,200 $1,500
Total Assets $9,600 $6,800
Liabilities and Stockholders’ Equity
Current Liabilities
Accounts Payable $2,800 $1,700
Notes Payable 1,100 1,900
Total Current Liabilities $3,900 $3,600
Long-Term Liabilities
Bonds Payable 4,100 2,100
Total Liabilities $8,000 $5,700
Stockholders’ Equity
Common Stock $200 $200
Retained Earnings 1,400 900
Total Stockholders’ Equity $1,600 $1,100
Total Liabilities and Stockholders’ Equity $9,600 $6,800

LONE PINE COMPANY
Statement of Income and Retained Earnings
For the Year Ending December 31,20X2 ($000 Omitted)
Net Sales* $36,000
Less: Cost of Goods Sold $20,000
Selling Expense 6,000
Administrative Expense 4,000
Interest Expense 400
Income Tax Expense 2,000 32,400
Net Income $3,600
Retained Earnings, Jan. 1 900
Ending Retained Earnings $4,500
Cash Dividends Declared and Paid 3,100
Retained Earnings, Dec. 31 $1,400
*All sales are on account.

Instructions
Compute the following items for Lone Pine Company for 20X2, rounding all calcu¬lations to two decimal places when necessary:
a. Quick ratio
b. Current ratio
c. Inventory-turnover ratio
d. Accounts-receivable-turnover ratio
e. Return-on-assets ratio
f. Net-profit-margin ratio
g. Return-on-common-stockholders’ equity
h. Debt-to-total assets
i. Number of times that interest is earned

For getting the instant download solution, Please click on the “PURCHASE” link below to get Edison, Stagg, and Thornton have the following financial information_Answer

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

excel-icon

Week 2 Case Analysis: Conference Decision Case In less than two weeks, an accounting system user’s conference is scheduled to be held in New Orleans, Louisiana Answer

MGMT 530 Managerial Decision Making Week 2_CaseAnalysis A+ Complete Answer

Week 2 Case Analysis: Conference Decision Case

Date: September 2, 2005

In less than two weeks, an accounting system user’s conference is scheduled to be held in New Orleans, Louisiana on September 13–16, 2005. Unfortunately, Hurricane Katrina has struck the city leaving a wake of destruction. Based on what you see on television, the hotel and the city cannot possibly accommodate this or any conference for the foreseeable future.

Approximately 200 attendees are scheduled to attend, flying in from all over the country. All attendees pre-paid their registration fee for the conference.

With a lot of competition in the marketplace, getting the users to participate in the annual user’s conference is critical to retain current customers. During the conference, several product enhancement ideas are developed by the users, and this input is often used in future releases of the product.

Potential new customers are invited to the event and their involvement often leads to securing new contracts for the accounting system as they gain confidence in the system seeing others use it.

As head of the group that puts on the conference, you are faced with making a determination of what to do with this year’s conference. You are getting calls from the registered attendees asking what to do. Senior management feels that the conference is critical to ensure continued customer engagement and fears that cancelling the conference altogether, the company will lose the momentum it has developed over the past few years.

Other considerations:
•Keeping the original dates and moving to a different city may drastically increase costs due to the short advanced notice. Will people cancel because of the higher hotel costs?
•If the date is changed, will the speakers and attendees still be able to attend?
•Having worked with the local Convention & Visitor’s Bureau and the hotel, you worry about how their businesses will survive with all of this destruction and wonder what you can do to help.

Using the same information from last week’s Case Analysis, build on the work you did last week by identifying the following.
1.Define the objectives for the Conference Decision Case. The objectives should be separated into fundamental and means objectives.
1.Identify the alternatives for the case.

For additional resources pertaining to this assignment, please review the Decision Making Drag and Drop Interactive found under the Week 2 Lecture tab. Additionally, an Overview of Decision Making Objectives can be found here. An example utilizing fundamental and means objectives can be found here. These documents can also be found in the Doc Sharing tab.

Submit your definition of the problem in a MS Word document to the Week 2 Case Analysis Dropbox. Input your responses in the template found here. This document is also posted in the Doc Sharing tab.

For getting the instant digital download answer, Please click on the “PURCHASE” link below to get MGMT 530 Managerial Decision-Making_Week2_CaseAnalysis_Answer

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

word_icon[1]

Shown below is the activity for one of the products of Random Creations Answer

The following information is provided in the 2011 annual report to shareholders of The Biz Store Answer

Intermediate Accounting I Part A
20 Point Questions (3 questions x 20 points = 60 total points)
Show all work.
1. The following information is provided in the 2011 annual report to shareholders of The Biz Store:
December 31, 2011 December 31, 2010
Accounts Receivable Y $ 6 million
Inventory $ 25 million $ 20 million
Total assets $ 250 million X
Total Stockholders’ Equity W $ 130 million
Net Sales $ 115 million
Cost of goods sold Z
Net Income U
Average Collection Period 22.2 days
Average days in inventory 104 Days
Equity multiplier 1.9
Return on stockholders’ Equity 16.0 %
Profit Margin on sales 17.4 %
ROA V
Required: Compute U-Z in the table above.

2. Shown below is the activity for one of the products of Random Creations:
January 1 balance, 80 units @ $50 $4,000
Purchases:
January 18: 40 Units @ $51
January 28: 40 Units @ $52
Sales:
January 12: 30 Units
January 22: 30 Units
January 31:45 Units
2a. Compute the ending inventory and cost of goods sold assuming Random Creations uses FIFO.
2b. Compute the ending inventory and cost of goods sold assuming Random Creations uses LIFO and perpetual inventory system.
2c. Compute the ending inventory and cost of goods sold assuming Random Creations uses LIFO and a periodic inventory system.
2d. Compute the ending inventory and cost of goods sold assuming Random Creations uses average cost and a periodic inventory system.
2e. Compute the ending inventory and cost of goods sold assuming Random Creations uses average cost and a perpetual inventory system.

3. On January 3, 2011, Michelson & Sons acquired a tract of land just outside the city limits. The land and existing building were purchased for $2.4 million. Michelson paid $400,000 and signed a noninterest-bearing note requiring the company to pay the remaining $2,000,000 on December 31, 2012. An interest rate of 7% properly reflects the time value of money for this type of loan agreement. Transfer taxes, title insurance and other costs totaling $24,000 were paid at closing. During February, the old building was demolished at a cost of $120,000, and an additional $100,000 was paid to clear and grade the land. Construction of a new building began on March 1 and was completed on October 30. Construction expenditures were as follows:
March 30 $ 800,000
June 30 1, 200,000
July 30 1,200,000
September 1 600,000
Michelson did not borrow specifically for the construction project, but did have the following debt outstanding throughout 2011:
$6,000,000, 8% long-term note payable
$2,000,000, 5% long-term note payable
In December, the company purchased equipment and office furniture and fixtures for a lump-sum price of $800,000. The fair values of the equipment and the furniture and fixtures were $540,000 and $360,000, respectively. In December, Michelson paid $340,000 for the construction of parking lots and landscaping.
Required:
3a. Determine the initial values of the various assets that Michelson acquired or constructed during 2011.
3b. How much interest expense will Michelson report in its 2011 income statement?

Part B
4 points Questions (10 questions x 4 points = 40 total points)
Show all Works
1. Tri Fecta, partnerships, had revenues of $360,000 in its first year of operations. The partnership has not collected on $35,000 of its sales, and still owes $40,000 on $150,000 of merchandise they purchased. There was no inventory on hand at the end of the year. The partnership paid $25,000 in salaries. The partners invested $40,000 in the business and $25,000 was borrowed on a five-year note. The partnership paid $3,000 in interest that was the amount owed for the year and paid $8,000 a two-year insurance policy on the first day of business.
Required
1a. Compute net income for the first year for Tri Fecta.
2a. Compute the cash balance at the end of the first year for Tri Fecta.
2. Presented below is a partial trial balance for the Messenger Corporation at December 31, 2011.
Account Title Debits Credits
Cash and Cash Equivalents 30,000
Account Receivable 195,000
Raw materials inventory 36,000
Note receivable 120,000
Interest receivable 4,000
Interest Payable 7,000
Marketable securities 48,000
Land 100,000
Buildings 1,500,000
Accumulated depreciation-buildings 740,000
Work in process inventory 38,000
Finish goods inventory 98,000
Equipment 400,000
Accumulated depreciation – equipment 230,000
Franchise (Net of amortization) 120,000
Prepaid insurance (for the next year) 60,000
Unearned revenue 48,000
Accounts payable 240,000
Note payable 500,000
Salaries Payable 6,000
Cash restricted for payment of Note Payable 100,000
Allowance for uncollectible Accounts 24,000
Sales revenues 900,000
Cost of goods sold 500,000

For getting the instant download solution, Please click on the “PURCHASE” link below to get “The following information is provided in the 2011 annual report to shareholders of The Biz Store Answer”.

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

word_icon[1]

Linear Programming Model A hospital is planning an $8 million addition to its existing facility Answer

Linear Programming Model _Excel Solution Module 6 P6-16_P6-30_P7-18_Answer

Problem P 6-16

A hospital is planning an $8 million addition to its
existing facility. The architect has been asked to con-
sider the following design parameters: (1) There should
be at least 10 and no more than 20 intensive care unit
(ICU) rooms; (2) there should be at least 10 and no

more than 20 cardiac care unit (CCU) rooms; (3) there
should be no more than 50 double rooms; (4) there
should be at least 35 single rooms; and (5) all patient
rooms should fit inside the allotted 40,000-square-foot
space (not including hallways). The following table
summarizes the relevant room data:
SINGLE DOUBLE ICU CCU
Cost per room to build and furnish ($thousands) $45 $54 $110 $104
Minimum square feet required 300 360 320 340
Profit per room per month ($thousands) $21 $28 $ 48 $ 41

How many rooms of each type should the architect
include in the new hospital design?

Problem P 6-30

6-30 Sandy Edge is president of Edge File Works, a
firm that manufactures two types of metal file
cabinets. The demand for the two-drawer model
is 650 cabinets per week; demand for the three-
drawer cabinet is 400 per week. Edge has a weekly
operating capacity of 1,600 hours, with the two-
drawer cabinet taking 1.5 hours to produce and
the three-drawer cabinet requiring 2 hours. Each
two-drawer model sold yields a $12 profit, and
the profit for the three-drawer model is $14. Edge
has listed the following goals, in rank order:
Rank 1: Attain a profit as close to $12,000 as pos-
sible each week.
Rank 2: Avoid underutilization of the firm’s pro-
duction capacity.
Rank 3: Sell as many two- and three-drawer cabi-
nets as the demand indicates.
Set up and solve this problem as a goal program-
ming model.

Problem 7-18

7-18 A plant engineering group needs to set up an assem-
bly line to produce a new product. The table in the
next column describes the relationships between the
activities that need to be completed for this product
to be manufactured.
(a) Develop a project network for this problem.
(b) Determine the expected duration and variance
for each activity.

(c) Determine the EST, EFT, LST, LFT, and slack
for each activity. Also determine the total project
completion time and the critical path(s).
(d) Determine the probability that the project will be
completed in less than 34 days.
(e) Determine the probability that the project will
take more than 29 days.

ACTIVITY DAYS IMMEDIATE
PREDECESSORSa m b

Problem 7-18
Activity Pred Optim time (a) Most likely time (m) Pessim time (b) Expected time Variance Standard deviation EST EFT LST LFT Slack Critical?
0.00 0.00 0.00 0.00 0.00 Y
0.00 0.00 0.00 0.00 0.00 Y
Y
Y
Y
Y
Y
Y
Y

Critical path =
Project length = 0.00 days
Project variance = 0.00
Project std deviation = 0.00 days
P(Finish < = 34 days) = #NUM! P(Finish >= 29 days) = #NUM!

For instant digital download of the solution, Please click on the “PURCHASE” link below to get Linear Programming Model _Excel Solution Module 6 P6-16_P6-30_P7-18_Answer

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

excel-icon

Linear Programming Model Steve’s Mountain Bicycle Shop is considering three options for its facility next year Answer

Linear Programming Model _Excel Solution Module 7 Problem P8-14_P8-28_P9-16_P9-20_Excel_ Answer

Linear Programming Model _Excel Solution Module 7 Problem P8-14_P8-28_P9-16_P9-20_Excel_ Answer

Problem P 8-14

Steve’s Mountain Bicycle Shop is considering three options for its facility next year. Steve can expand his current shop, move to a larger facility,
or make no change. With a good market, the annual payoff would be $76,000 if he expands, $90,000 if he moves, and $40,000 if he does nothing. With
an average market, his payoffs will be $30,000,
$41,000, and $15,000, respectively. With a poor
market, his payoff will be – +17,000, – +28,000, and
$4,000, respectively.
(a) Which option should Steve choose if he uses the
maximax criterion?
(b) Which option should Steve choose if he uses the
maximin criterion?
(c) Which option should Steve choose if he uses the
equally likely criterion?
(d) Which option should Steve choose if he uses
the criterion of realism with a = 0.4?
(e) Which option should Steve choose if he uses
the minimax regret criterion?

Question

Problem P 8-28

Jerry Young is thinking about opening a bicycle shop in his hometown. Jerry loves to take his own bike on 50-mile trips with his friends, but he believes that any small business should be started only if there is a good chance of making a profit. Jerry can open a small shop, a large shop, or no shop at all. Because there will be a five-year lease on the building that Jerry is thinking about using, he wants to make sure that he makes the correct decision. Jerry has done some analysis about the profit-ability of the bicycle shop. If Jerry builds the large bicycle shop, he will earn $60,000 if the market is good, but he will lose $40,000 if the market is bad. The small shop will return a $30,000 profit in a good
market and a $10,000 loss in a bad market. At the
present time, he believes that there is a 59% chance
that the market will be good.
Jerry also has the option of hiring his old mar-
keting professor for $5,000 to conduct a marketing
research study. If the study is conducted, the results
could be either favorable or unfavorable. It is esti-
mated that there is a 0.6 probability that the survey
will be favorable. Furthermore, there is a 0.9 proba-
bility that the market will be good, given a favorable
outcome from the study. However, the marketing
professor has warned Jerry that there is only a prob-
ability of 0.12 of a good market if the marketing
research results are not favorable.
(a) Develop a decision tree for Jerry and help him
decide what he should do.
(b) How much is the marketing professor’s infor-
mation worth? What is the efficiency of this
information?

Problem P 9-16

The wheat harvesting season in the U.S. Midwest is short, and most farmers deliver their truckloads of wheat to a giant central storage bin within a two-
week span. Because of this, wheat-filled trucks waiting to unload and return to the fields have been known to back up for a block at the receiving bin.
The central bin is owned cooperatively, and it is to every farmer’s benefit to make the unloading/storage process as efficient as possible. The cost
of grain deterioration caused by unloading delays
and the cost of truck rental and idle driver time are
significant concerns to the cooperative members.
Although farmers have difficulty quantifying crop
damage, it is easy to assign a waiting and unloading
cost for truck and driver of $18 per hour. The stor-
age bin is open and operated 16 hours per day, seven
days per week during the harvest season and is
capable of unloading 35 trucks per hour, according
to an exponential distribution. Full trucks arrive all
day long (during the hours the bin is open), at a rate
of about 30 per hour, following a Poisson pattern.
To help the cooperative get a handle on the
problem of lost time while trucks are waiting in line
or unloading at the bin, find the
(a) average number of trucks in the unloading
system
(b) average time per truck in the system
(c) utilization rate for the bin area
(d) probability that there are more than three trucks
in the system at any given time
(e) total daily cost to the farmers of having their
trucks tied up in the unloading process
(f) The cooperative, as mentioned, uses the storage
bin only two weeks per year. Farmers estimate
that enlarging the bin would cut unloading costs
by 50% next year. It will cost $9,000 to do so
during the off-season. Would it be worth the
cooperative’s while to enlarge the storage area?

Problem P 9-20

Carlos Gomez is the receiving supervisor for a large grocery store. Trucks arrive to the loading dock at an average rate of four per hour, according to a Pois-
son distribution, for 8 hours each day. The cost of operating a truck is estimated to be $80 per hour. Trucks are met by a three-person crew, which is able
to unload a truck in an average of 12 minutes, according to an exponential distribution. The payroll cost associated with hiring a crew member, includ-
ing benefits, is $22 per hour. Carlos is now considering the installation of new equipment to help the crew, which would decrease the average unload-
ing time from 12 minutes to 9 minutes. The cost of this equipment would be about $500 per day. Is the installation of the new equipment economically
feasible?

For instant digital download of the solution, Please click on the “PURCHASE” link below to get Linear Programming Model _Excel Solution Module 7 Problem P8-14_P8-28_P9-16_P9-20_Excel_ Answer

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

excel-icon

Linear Programming Model Highland Automotive wishes to forecast the number of new cars that will be sold next week Answer

Linear Programming Model _Excel Solution Module 8 Problem P11-20_P11-28_P12-24_P12-26_Excel_ Answer

Problem P 11-20

Highland Automotive wishes to forecast the number
of new cars that will be sold next week. The follow-
ing table summarizes the number of new cars sold
during each of the past 12 weeks:

WEEK NUMBER SOLD (a) Provide a forecast by using a 3-week weighted
1 22 moving average technique with weights 5, 3, and
2 26 1 (5 = most recent).
3 23 (b) Forecast sales by using an exponential smooth-
4 27 ing model with a = 0.45.
5 21 (c) Highland would like to forecast sales by using
6 25 linear trend analysis. What is the linear equation
7 28 that best fits the data?
8 26 (d) Which of the methods analyzed here would you
9 29 use? Explain your answer.
10 29
11 27
12 31

Problem P 11-28

Consider the patient data for Dr. Schalkoff given in
Problem 11-27.
(a) Draw the relationship between the crime rate and
Dr. Schalkoff’s patient load. Is a linear model
between these two variables reasonable?
(b) Apply linear regression to study the relationship
between the crime rate and Dr. Schalkoff’s pa- Year Number of Patients Crime Rate
tient load. 1 30 67.3
(c) If the crime rate increases to 140.2 in year 11, 2 27 70.6
how many patients will Dr. Schalkoff treat? 3 34 82.4
(d) If the crime rate drops to 98.6, what is the patient 4 35 84.7
projection? 5 34 90.1
6 49 98
7 54 110.1
8 48 103.8
9 52 112.3
10 55 125.2

Problem P12-24

Blaine Abrams is the owner of a small company
that produces electric scissors used to cut fabric.
The annual demand is for 75,000 scissors, and
Blaine produces the scissors in batches. On average, Blaine
can produce 1,000 pairs of scissors per day
during the production process. Demand for
scissors has been about 250 pairs of scissors per
day. The cost to set up the production process is
$800, and it costs Blaine $0.90 to carry 1 pair of
scissors for one year. How many scissors should
Blaine produce in each batch?

Problem P12-26

Chandler Manufacturing has a demand for 1,000
pumps each year. The cost of a pump is $50. It
costs Chandler Manufacturing $40 to place an
order, and the carrying cost is 25% of the unit cost.
If pumps are ordered in quantities of 200, Chandler
Manufacturing can get a 3% discount on the cost of
the pumps. Should Chandler Manufacturing order
200 pumps at a time and take the 3% discount?

For instant digital download of the solution, Please click on the “PURCHASE” link below to get Linear Programming Model _Excel Solution Module 8 Problem P11-20_P11-28_P12-24_P12-26_Excel_ Answer

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

excel-icon