Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Business Finance – Accounting assignment

Optimization Group Project Instructions


Instructions

This is a group assignment. In order to complete the assignment, first read the “Hawley Lighting Company” case study. Conduct necessary calculations and answer the questions listed below. Submit your Excel spreadsheet(s) with calculations to the assignment dropbox before the posted deadline.

Prepare a
properly formatted

Management Report

, which includes your answers to the assignment questions. Include cover page and appropriate references.


Grading

A total of 20 points is possible for this assignment. This includes the point values which are assigned to each question (point values are noted next to each question below). This includes the point values which are assigned to each question (point values are noted next to each question below) plus 2 points which are earned based on following the prescribed assignment format, and the proper writing style including APA format.

For full credit for Parts A and B, you must turn in your spreadsheet with dynamically coded formulas (not hard-coded numbers).

1.
Spreadsheet Model (in Excel)

Part A (3 points). Read the case study “Hawley Lighting Company”. Download Hawley Data Fall23.xlsx file and complete the model:

· Calculate Unit Profit for each product (in cells B8:I8) and Total Profit (in cell B19)

· Calculate total capacity required in Department 1 (overtime) in cell B24 and Department 2 (regular and overtime) in cells B25:B26

· Calculate total units produced of each product family in cells B28:B31.

Estimate the optimal production plan and run the sensitivity analysis.

Part B (2 points). A third-party company approached Hawley’s management offering to assemble and produce pendant lights for $27 per unit. Modify the production plan model in Part A to include the pendant light outsourcing. Assume the advertising budget with $18,000 limit. Estimate new optimal production plan and run the sensitivity analysis.

2.
Management Report (in Word)

Part C (13 points). Prepare a
management report, discussing the analysis results obtained in Part A and Part B. The report should include the following sections and must answer the following questions:

1. Executive Summary.

2. Problem Statement.

3. Analysis. This section must include the following information:

a. Describe the method of analysis used to answer the case questions and explain why it was used to address the case problems.

b. Analyze the tactical and strategic information provided by the optimal solution and sensitivity report in
Part A:

· What is an optimal output plan for the company?

· What factors could lead to even better level of performance:

· For each department, what is the
marginal value of additional overtime capacity?

· What is the
marginal value of additional advertising dollars?

· What is the
marginal value of additional sales for each product?

· What is the trade-off between advertising expenditures and increased sales for Hawley Co. If the advertising budget to be increased, how it would affect the production plan? Assume that you increased the advertising budget by the amount of the
allowable increase, how this advertising budget change would affect the optimal production plan? (1 point)

c. Analyze the optimal solution obtained in
Part B:

· Should the Hawley’s management consider the offer? If yes, how much of pendant light units should be outsourced and how many units should be produced in-house. (0.5 points)

4. Conclusions and Recommendations.

· Summarize your conclusions and provide recommendations on optimal production strategy and on how, in your opinion, Hawley Co. should coordinate advertising and sales of different products?

5. Bibliography. Include appropriate references and follow APA style.

1

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Link Alternatif Nagapoker: A Reliable Solution for Uninterrupted Access

 What Is Link Alternatif Nagapoker?  Link Alternatif Nagapoker: A Reliable Solution for Uninterrupted Access What Is Link Alternatif Nagapoker? Link Alternatif Nagapoker refers to an alternative access link provided to ensure players can still reach the platform when the main website is unavailable. This situation often occurs due to internet

Assessing Organizational Viability

  Scenario You are the CFO of a rural hospital. During a recent review of the organization’s financial status, the hospital was deemed “at risk” for closure. Several factors contribute to the at-risk designation, including the state’s decision to opt-out of the Medicaid expansion program, the aging population which requires

Deliverable 1 – Community Needs Assessment

  Scenario Your local health system is planning to launch its new population health management (PHM) program for the community and population it serves. You are the Chief Population Officer for this system, and you were tasked by your system CEO to develop key performance indicators for this program. One of the

Case Scenario

The company you work for has spent years developing a new, innovative product. The company has spent large sums on a product which management believes will be cutting edge. Forecasts look promising and indicate the device will be highly profitable. It goes without saying the company will gain a dominant position

HRM 6304 Unit I DBR

2 Labor Relations and Collective Bargaining HRM 6304 Unit I Discussion Board Reply Posts to others should be a minimum of 250 words. You should also include at least two references. Reply to the below Top of Form The structural landscape of the American labor movement changed significantly in 2005

Business Finance – Management Week 9 Assignment- Managerial Finance

Module 3 Assignment: Capital Budget Decision Making for an Organization Report prepared by: Replace this text with your name. Date: Replace this text with the submission date. Walden University MBAX 6070: Managerial Finance 1 Executive Summary Replace this text with your executive summary. Part 1: Short-Term Working Capital Considerations Replace

Logistics

see attached  BUSI 615 Integrated Learning Project Assignment Instructions Overview The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final consolidated submission is managed as an individual assignment. Purpose The purpose of the ILP is for

HRM 6304 Unit I DB

2 Labor Relations and Collective Bargaining HRM 6304 Unit I Discussion Board In your opinion, does having two different existing labor federations (i.e., American Federation of Labor and Congress of Industrial Organizations [AFL-CIO] and Change to Win) strengthen or weaken the ability of organized labor to represent the interests of

Which of the following is a topic of macroeconomics?

 Which of the following is a topic of macroeconomics? A) why nations have different rates of growth B) what causes inflation and what can be done about it C) why unemployment periodically reaches very high levels D) all of the above

Business Finance – Management Week 9 Assignment- Delivery of Healthcare

Delivery of Healthcare Week 9 Assignment Improvement Plan- Part 2 This week, you should continue your Improvement Plan: Part 2. As you work on your Improvement Plan, be sure to incorporate peer-review feedback (as appropriate). This week, focus on the areas of: · Information technology (value-based care model) · Be

Business Finance – Accounting Assignment Week 2

 Tax Research using Code and Administrative Sources. Facts: You are a slightly over-confident  CPA who advises Changling Industries, LLC, a Florida Manager Managed  LLC a small start up limited liability that has garnered the attention  of several Angel Financing organizations. The founder, Nodan Idiote, of  middle-eastern origin and three of

Ecosystems

   Do you think the introduction of non-native species to an ecosystem always pose a threat to that ecosystem? 

Innovative and Strategic Thinking

Market entry, discussing details.  Market Entry The Impact of Innovation The graduate identifies the impact of innovation in personal and professional settings. Techniques of Strategic Management The graduate utilizes evidence-based techniques to make strategic decisions. Business Strategy and Analysis The graduate applies appropriate business practices to formulate recommendations that impact

Week 3 pj

 wood-based shipping container and a plastic-based shipping  Instructions:  You are going to compare and contrast the advantages and disadvantages of a paper- based shipping container, a wood-based shipping container and a plastic-based shipping container for use as a distribution package (a non-retail shipping package). You must consider the entire supply chain in

Week 3 MGMT618

 Workplace scenario involving an observed unethical  Assignment Directions This assignment assesses  CO-3 [content page].  Students will provide a workplace scenario involving an observed unethical practice. Submission Instructions: Write a 5–7 page report analyzing the situation, evaluating potential responses, and recommending the most ethically sound course of action. Requirements: Use at least

A22- Discussion

 Additionally, you will explore the concept of Relationship Marketing and, in particular, you will focus on Differentiating Customers by Their Needs. Please answer these questions and use scholarly support for your answers: 

Week 8

 building blocks from the business model canvas where modification  Assignment Directions: Goal: Conduct/construct an experiential evaluation/assessment of your organization’s business model (or one with which you are closely familiar) using the business model canvas and related text. Introduction: Managers who want to improve the effectiveness of their business model and