Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

The Pine Furniture Company makes fine country furniture. The company's current product lines consist of end tables, coffee tables, and dining room tables. The production of each of these tables requires 8, 15, and 80 pounds of pine wood, respectively. The tables are handmade and require one hour, two hours, and four hours. Each table sold generates $50, $100, and $220 profit. The company has 3,000 pounds of pine wood and 200 hours of labor available for the coming week's production. The chief operating officer (COO) has asked you to do some spreadsheet modeling with this data to analyze what the product mix should be for the coming week and make a recommendation.

a. Visualize where you want to finish. What numbers will the COO need? What are the decisions that need to be made? What should the objective be?

b. Suppose that Pine furniture were to produce three end tables and three dining room tables. find out by hand the amount of pine wood and labor that would be required, as well as the profit generated from sales.

c. Make a rough sketch of a spreadsheet model, with blocks laid out for the data cells, changing cells, output cells, and target cell.

d. Build a spreadsheet model and then solve it.

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M926992

Have any Question? 


Related Questions in Basic Finance

Staton-smith software is a new start-up company and will

Staton-Smith Software is a new start-up company and will not pay dividends for the first five years of operation. It will then institute an annual cash dividend policy of $5.00 with a constant growth rate of 3%, with the ...

1 what ratios are used to indicate profitability for banks2

1. What ratios are used to indicate profitability for banks? 2. Why are banks concerned about the percentage of earning assets to total assets? 3. What does the loan loss coverage ratio measure? 4. What type of ratio is ...

Discussionmiddot managed care contracting and ratio

Discussion · Managed Care Contracting and Ratio Analysis" · From the scenario, interpret the operating indicators used to analyze the financial performance of the organization. Indicate specific ways in which this inform ...

How do international factors affect decision making

How do international factors affect decision making? Although the same basic principles of capital budgeting apply to both foreign and domestic operations, there are some key differences. For example, cash flows must be ...

1 describe and illustrate an integrated service provider

1. Describe and illustrate an integrated service provider. How does the concept of integrated service provider differ from traditional service providers, such as forhire transportation and warehousing? 2. Compare and con ...

Norman jones an economic historian at the university of

Norman Jones, an economic historian at the University of Utah, has described the view of the ancient Greek philosopher Aristotle on interest: Aristotle defined money as a good that was consumed by use. Unlike houses and ...

1 when an author submits a manuscript to a journal what is

1. When an author submits a manuscript to a journal, what is the general process by which the decision whether or not to publish the paper is made? 2. Distinguish between a paper session and a poster session.

1 what do you see as the biggest challenges in conducting a

1. What do you see as the biggest challenges in conducting a brand audit? What steps would you take to overcome them? 2. Pick a brand. See if you can assemble a brand inventory for it.

1 in freight transportation a typical logistics problem is

1. In freight transportation, a typical logistics problem is the allocation of empty containers to depots, in order to satisfy future demands of transportation services. How can a carrier predict demands of containers fo ...

Dod pentagon budgetdiscuss how the department of defense

DoD Pentagon Budget Discuss how the Department of Defense and the Pentagon cannot account for some $6.5 trillion which illustrates the issue of accountability in public administration including the leadership within the ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro