Get help from the best in academic writing.

University of North Carolina Wilmington Simple Linear Programming Excel Task

University of North Carolina Wilmington Simple Linear Programming Excel Task.

I need the same thing as last week. 2 Homework questions answered using Solver in excel.1. Lincoln Lock Company The Lincoln Lock Company manufactures a commercial security
lock at plants in Atlanta, Louisville, Detroit, and Phoenix. The unit cost of production at each
plant is $35.50, $37.50, $37.25, and $36.25, and the annual capacities are 18,000, 15,000, 18,000,
and 20,000, respectively. The locks are sold through wholesale distributors in seven locations
around the country. The unit shipping cost for each plant– distributor combination is shown in the
following table, along with the forecasted demand from each distributor for the coming year. Set
this problem as a network flow model and determine the least costly way of shipping locks from
plants to distributors. plants to distributors.
Tacoma SanDiego Dallas Denver StLouis Tampa Baltimore
Atlanta 2.50 2.75 1.75 2.00 2.10 1.80 1.65
Louisville 1.85 1.90 1.50 1.60 1.00 1.90 1.85
From: Plants Detroit 2.30 2.25 1.85 1.25 1.50 2.25 2.00
Phoenix 1.90 0.90 1.60 1.75 2.00 2.50 2.65
Demand 5500 11500 10500 9600 15400 12500 66002. Assigning Tasks Suppose a data processing department wishes to assign five programmers
to five programming tasks (one programmer to each task). Management has estimated the total
number of days each programmer would take if assigned to the different jobs, and these estimates
are summarized in the following table.
Task 1 2 3 4 5
1 50 25 78 64 60
2 43 30 70 56 72
Programmer 3 60 28 80 66 68
4 54 29 75 60 70
5 45 32 70 62 75
1. Determine the assignment that minimizes the total programmer days required to complete
all five jobs.
University of North Carolina Wilmington Simple Linear Programming Excel Task

Extent of competition in the banking industry

Corporate services — fixed cost Hourly personnel is a variable cost because the cost is dependent upon how many revenue hours are worked by the staff. If they sell for 0 hours, there is still a rent expense. Power is a variable cost because the cost is directly related to the number of hours computers were used in operation. The more hours used, the higher the cost of power. Rent is a fixed cost because it must be paid no matter how many hours the company is operating. Rent must be paid whether the company is selling or not. Custodial services is a fixed cost because it is based on Salem Telephone’s estimated annual cost per square foot. It is not dependent on the amount of revenue hours. Computer leases is a fixed cost because it is independent of revenue hours. This cost will stay the same regardless of the amount of revenue hours. Maintenance is a fixed cost because it is not dependent on the number of revenue hours. Depreciation on computer equipment does not depend on the amount of revenue hours. Depreciation on office equipment is not dependent upon revenue hours. Salaried staff is paid a salary regardless of the amount of revenue hours. The amount the staff is paid is not affected by a change in revenue hours. System maintenance is not dependant on the hours of selling Administration salary is not related to the amount of revenue hours. Sales wages does not depend on the amount of revenue hours. Sales promotion does not vary with a change in revenue hours. Corporate services is a fixed cost because the amount is not dependent upon the number of revenue hours. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour. Power cost per revenue hour: January: $1,546/329 hours = $4.70 February: $1,485/316 hours = $4.70 March: $1,679/361 hours = $4.70 Operations: hourly personnel: January: $7,896/329 hours = $24.00 February: $7,584/316 hours = $24.00 March: $8,664/361 hours = $24.00 Variable costs in total change in direct proportion to changes in volume of activity but remains constant per unit when the volume of activity changes. Create a contribution margin income state for Salem Data Services. Assume that intracompany usage is 205 hours. Assume commercial usage is at the March level. **See Exhibit 1 Assuming the intracompany demand for service will average 205 hours per month, what level of commercial revenue hours of computer use would be necessary to break even each month? Break-even point = Fixed costs/ CM per unit Sales revenue per unit = $82,000/205= $400.00 Variable cost per unit = $9,844.10/343= $28.70 (205 x $400 A x $800) – 28.70 x (205 A) – 212,939 = 0 82,000 800A – 28.70A – 5883.50 – 212,939 = 0 -136,822.50 771.30A = 0 771.30 A = 136,882.50 A = 177.39 Salem Data Services would need 177.39 commercial hours to break even. Estimate the following effect on income of each of the options Floes has suggested if Wu estimates as follows: Increasing the price to commercial customers to $1,000 per hour would reduce demand by 30%. Commercial revenue hours = 138 With a 30% decrease in demand, commercial revenue hours would be reduced to: 138 x 30% = 41.4 138 – 41.4 = 96.6 hours Revenue Intracompany sales (205x$400) $82,000 Commercial sales (96.6x$1,000) 96,600 Less: VC (301.60×28.70) (8,655.92) CM 169,944.08 Less: FC (212,939) Net Income ($42,994.92) This option would result in an additional loss of ($12,611.92) leaving a total net loss of ($42,994.92). Reducing the price to commercial customers to $600 per hour would increase demand by 30% Commercial revenue hours = 138 With a 30% increase in demand, commercial revenue hours would increase to: 138 x 30% = 41.4 138 41.4 = 179.4 hours Revenue Intracompany sales (205x$400) $82,000 Commercial sales (179.4x$600) 107,640 Less: VC (384.4x$28.70) (11,032.28) CM 178,607.72 Less: FC (212,939) Net Income ($34,331.28) This option would result in an additional loss of ($3,948.28) resulting in a total net loss of ($34,331.28). Increased promotion would increase revenue hours by up to 30%. Wu is unsure how much promotion this would take. (How much could be spent and still leave Salem Data Services with no reported loss each month if commercial hours were increased 30%?) Commercial revenue hours = 138 Commercial revenue hours with a 30% increase = 138 x 30% = 41.4 138 41.4 = 179.4 hours Revenue Intracompany sales (205x$400) $82,000 Commercial sales (179.4x$800) 143,520 Less: VC (384.4x$28.70) (11,032.28) CM 214,487.72 Less: FC (212,939) Net Income $1,548.72 The maximum amount that could be spent and still leaves Salem Data Services with no reported loss each month if commercial hours were increased 30% would be $1,548.72. Salem Data Services spent $8,083 on sales promotion in March. Therefore, a total of $9,631.72 ($1,548.72 $8,083) could be spent on sales promotion without incurring a net loss. Based on your analysis above, is Salem Data Services really a problem to Salem Telephone Company? What should Flores do about Salem Data Services? Based on our analysis above, we feel that Salem Telephone Company should keep Salem Data Services. Although Salem Data Services’ fixed costs are very high and profits have not been obtained in previous periods, Salem Telephone Company should maintain Salem Data Services. Exhibit 2 shows that the net loss from February to March decreased $16,987. If Salem Telephone Company were to shut down Salem Data Services, the company would save a large amount of money in fixed costs but would have to spend money to make up for the intracompany revenue hours. Salem should keep Salem Data Services in operations, regardless of showing a net loss. If Data Services closed, Salem would incur the following additional costs: Purchase of intracompany hours (at market cost): 205 hours x $800 = $164,000 Fixed costs saved if SDS closed (March): Rent $8,000 Custodial services $1,240 Maintenance $5,400 Power $1,697 Operations: salaried staff $21,600 Operations: hourly personnel $8,664 Systems development $12,000 Administration $9,000 Sales $11,200 Promotions $8,083 Total savings $86,884 (205 hours x $800) $164,000 – Purchase of intracompany hours ($86,884) – Savings if Salem Data Services closed $77,116 – Cost savings for operating Salem Data Services In this situation, the benefits outweigh the costs. Salem Telephone Company would be saving $86,884 in costs but would have to purchase intracompany hours at $164,000. Flores should continue to operate Salem Data Services; however, they should focus on methods to cut costs by re-evaluating its labor necessities and increasing awareness through promotion to increase long-term profitability. Another aspect for Flores to take into consideration is to re-evaluate and forecast commercial sales willingness to pay in order to increase its break-even potential. From the analysis in question five, Flores could reduce the price to commercial customers, thereby increasing demand. Using this strategy in addition to cutting costs will increase Salem Data Services profitability.

journal

i need help writing an essay -What, if anything, makes you nervous about this class? -What do you know/understand about race in our current world? -How do you understand your race and racial identity? -What are some questions that you have about race and racism? -Do you have any questions about this class? -Is there anything in particular that you want me to know as we begin to start this class? You do not have to answer all of these questions, I just ask that you keep some of them in mind as you write. Please remember that you are being asked to write 2-3 pages minimum, but you are welcome to write more if you feel inclined to do so.

Business Memorandum

Business Memorandum.

Writing Requirements: In this final deliverable, students will demonstrate an understanding of the problem and fully develop all required elements of the memorandum for this writing assignment. Refer back to the Business Memorandum Guidelines found in the reading part of this assignment to find the formatting of the memorandum, the elements required, and the content to be included. Review and revise your pre-writing document using the input from your classmate to assist your own revision process. Be sure to edit the document for grammar and spelling prior to turning it in. For convenient reference, the assignment is included below. Step 1: Review Peer Review Feedback and Integrate Your Revisions Give careful consideration to all of the feedback provided by your peers. Determine which feedback you believe suggests improvements that you can make to your document and make the needed revisions to your document. As this is your work, you may decide you disagree with some comments or agree with the comment but not the recommended action; you do not need to implement suggestions you disagree with. Step 2: Return to the Memorandum Guide and Complete Missing Elements of Your Memorandum The work you did in the pre-writing assignment did not produce the complete memorandum. That assignment was designed to get you thinking about important elements of the assignment, without having to produce the entire document. You will take what you started and have revised and with the use of the Business Memorandum Guidelines, you will complete all elements of the memorandum being careful to remember who you are writing to. Problem Description: You are a line manager in Superior Car Part’s Ellisville manufacturing facility. The company produces automotive parts, and you have responsibility for the line producing steel shafts for the gearbox manufactured in the Ellisville Plant. The acceptable dimension of the shaft is 2.5±0.05 inches in diameter with the most desirable product having a diameter of exactly 2.5 inches. The current equipment is approaching the end of its useful life and needs to be replaced. Two vendors are trying to sell your company, Superior Car Parts Incorporated, their machines for the shaft-machining task. You have been asked to assess the machines from each vendor, and to make a recommendation for a machine vendor supported by a justification for your decision. You asked both vendors to supply data on the machining accuracy of their machines for the given task. Both vendors machined 100 shafts, collected data, plotted histograms, fitted the histograms with normal distributions and supplied you with their findings. Let X= diameter in inches of the gearbox shaft Abano Machines Inc.: X has a normal distribution with a mean of 2.49 and a standard deviation of 0.030 Li Equipment Corp.: X has a normal distribution with a mean of 2.53 and a standard deviation of 0.015 Audience: You are creating this document for the company’s Chief Operating Officer, (Links to an external site.) Lena George, and copying the Chief Financial Officer (Links to an external site.), Amita Kohli. Documents involved in major financial decisions like this may also be distributed by the addressees to other executives and the corporate board members. Rubric P&S Writing Assignment 2.4 2019F P&S Writing Assignment 2.4 2019F Criteria Ratings Pts This criterion is linked to a Learning OutcomeMemorandum header is completed The layout and content follow Document/Memorandum header instructions in “How to Write a Business Memorandum” 3.0 pts The memorandum header is complete 2.5 pts The memorandum header is weak in one area The Memorandum header is weak or incorrect in one element 2.0 pts The memorandum header is very poorly done or missing The Memorandum header is missing multiple elements, is substantially incomplete or incorrect, 0.0 pts The memorandum header is missing The memorandum header is weak in one area by otherwise well done. 3.0 pts This criterion is linked to a Learning OutcomeSummary is included and complete The Summary is included following the requirements in “How to Write a Business Memorandum” . The summary is clear, complete and consice. 4.0 pts The summary is well done The summary is complete, clear and concise 3.3 pts The summary is weak in a part The summary is weak in a part but otherwise well done. 2.6 pts The summary is missing or extremely poorly done 0.0 pts The summary is poorly done The summary is missing multiple elements and/or is poorly written and/or unclear 4.0 pts This criterion is linked to a Learning OutcomeAnalysis section is included An analysis section is included following the guidance in “How to Write a Business Memorandum”. The section is clear, complete and concise. (It is NOT a step-by-step presentation of the calculations.) 6.0 pts The analysis is well done The analysis is complete, clear, and concise. 5.0 pts The analysis section is weak in a part The analysis is weak in one part but otherwise well done. 4.0 pts The analysis section is poorly done The analysis is incomplete and/or unclear 0.0 pts The analysis section is missing or not completed in plain language The analysis section is missing or does not provide a plan language description, instead just walks through the calculations. 6.0 pts This criterion is linked to a Learning OutcomeGraphics are included to support the case you are making Graphics are included to support the case you are making The graphic(s) included must support your recommendation by making points more clearly than can be made in writing alone. They are clearly labeled including a figure or table label and number with a title that is located correctly. (review readings if needed) 3.0 pts Graphic(s) is/are well done Graphic(s) enhance the memorandum message, are clear, with all elements identified, accurately presented, and have a figure or table label with a number and title that is located correctly. 2.5 pts Graphic(s) is/are weak in a part raphic(s) is/are weak in one part but otherwise well done. 2.0 pts The graphic(s) is/are poorly done The graphics are unclear and/or unlabeled and do not enhance the memorandum clarity 0.0 pts Graphics are missing 3.0 pts This criterion is linked to a Learning OutcomeThe Additional Considerations section is included The additional Consideration section is included and well done. 4.0 pts The additional considerations section is included The additional considerations section is included, well thought out and well written. 3.3 pts The additional considerations section is weak in one area The additional consideration section is weak in one area by otherwise well done. 2.6 pts The additional considerations section is poorly done The additional considerations section is missing multiple elements or is substantially incomplete or incorrect 0.0 pts The additional considerations section is missing The additional considerations section is missing 4.0 pts This criterion is linked to a Learning OutcomeThe Additional Considerations section is exceptionally well thought out addressing a broad range of important business considerations For a student completing this section exceptionally well up to 2 additional points may be given 0.0 pts Full Marks 0.0 pts No Marks 0.0 pts This criterion is linked to a Learning OutcomeConclusion is included A conclusion is included that meets the requirements in “How to Write a Business Memorandum”. Additionally, the conclusion is clear, complete, and concise. 4.0 pts Conclusion is well done The conclusion is s complete, clear, and concise. 3.3 pts Conclusion is weak in one part The conclusion is weak in one area but otherwise well done. 2.6 pts The conclusion is poorly done The conclusion is incomplete, confusing or wordy 0.0 pts Conclusion is missing or very poorly done 4.0 pts This criterion is linked to a Learning OutcomeAppendix is included An appendix is included that presents your calculations (typewritten). The Statistical approach is and the outcome are correct. 2.0 pts Appendix is included with the full calculations 1.5 pts The Appendix is included but has an error The appendix is included but is missing an element. 0.0 pts The Appendix is missing 2.0 pts This criterion is linked to a Learning OutcomeThe assignment does not address the correct problem (minus 1 point) 0.0 pts Full Marks 0.0 pts Problem is not addressed – minus 1 point 0.0 pts This criterion is linked to a Learning OutcomeThe correct audience was not addressed (minus 1 point) 0.0 pts Full Marks 0.0 pts The correct audience was not addressed (minus 1 point) 0.0 pts This criterion is linked to a Learning OutcomeThe Appendix included uses the statistical calculations using the correct approach and getting the correct answer 4.0 pts Full Marks 3.7 pts The Appendix includes a statistical calculation that uses the correct approach but has a minor calculation error 2.5 pts The statistical approach is wrong or the calculations are wrong 0.0 pts No statistical calculation was included 4.0 pts Total Points: 30.0
Business Memorandum

Academy College Razor Scooter Sales Contract Descriptive Essay

Academy College Razor Scooter Sales Contract Descriptive Essay.

The contract you will be using is in the Contracts Module.You will be given a contract with questions to be answered for the contract. I am looking for the ability to read and comprehend the contract so the appropriate contract clause can be applied to the questions connected with the contract. In order to answer the contract fact scenario, you will also need to be able to identify the legal concept that is applicable to the situation described. This is an analysis so please treat it as such. Your personal opinion is not appropriate.There are correct answers for each question. If a student discusses a different legal theory for answering the questions, partial points will be given. In cases of complete or partial answers, readings references are mandatory to support the remedy proposed by the student. A reading reference that has no bearing on the remedy or legal arguments will be counted as “no reference”. For example, if any contract has an issue of risk of loss, referencing the text on contract formation will not meet the requirement.Please remember to reference the applicable parts of the contract that you are using to answer each question.This analysis is worth 21 points. Within each question, a student will be given 2 points for the text reference, 3 points for the contract reference, with 8 points for the analysis. Please remember, NO outside references. That will be an automatic point deduction and will not be considered a text reference.The remaining 2 points will be given as an a spelling/grammar score. Following are the prompts.UCC Sales ContractThe following question is based on the Sales Contract found in the Contracts Module. Please reference the Sales Contract by clause number as you answer the questions. Remember, this is a contract under the UCC.
Essay (2 complete paragraphs minimum per essay with text and contract references to support your answers)
You, the buyer, contend that you received non-conforming goods as a result of an ambiguity in the contract. You ordered goods thinking you would get a particular product. You wanted Razor scooters. That was the original oral communication when you first contacted the selling merchant. You both talked about and agreed on Razor scooters. Thereafter, in phone conversations, you and the seller just used the phrase scooters. The seller prepared a written contract. The contract was signed by both parties. The selling merchant then shipped scooters that are in perfect condition but they are not Razor scooters. The selling merchant believes the goods are conforming. Upon receipt and inspection of the goods, what are all your merchant options under the contract and at law?* (Why are text references important? Contract language does not exist in a vacuum. It is written based on the law. It is critical, therefore, to cite to the readings and the contract to support your analysis.) Do not use other references instead of the assigned readings. Remember, I also do plagiarism checks.
Academy College Razor Scooter Sales Contract Descriptive Essay

Essay Writing at Online Custom Essay

5.0 rating based on 10,001 ratings

Rated 4.9/5
10001 review

Review This Service




Rating: