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

A manufacturer of cream filled donuts wants to make sure

A manufacturer of cream filled donuts wants to make sure that its automatic filling process is on target. Based on a sample of 25 donuts the mean weight of cream filling is estimated to be 15 grams with a standard deviat ...

1 what are the criteria that investors should consider in

1. What are the criteria that investors should consider in determining whether to invest in load funds or no-load mutual funds? 2. List the major differences between a financial planner and broker. 3. What are the advant ...

According to an article in the wall street journal in late

According to an article in the Wall Street Journal, in late 2009, "Between Dec. 9 and 11, some big European and U.S. banks made bearish calls on the euro by buying one-year euro ‘puts.'" a. What is a "bearish call"? b. W ...

1 when preparing a personal statement of financial

1. When preparing a personal statement of financial condition, should assets and liabilities be presented on the basis of historical cost or estimated current value? 2. In a personal statement of financial condition, wha ...

1 describe why teams are being formed more frequently in

1. Describe why teams are being formed more frequently in business today. What are some of the special considerations required for a team to be successful? 2. Defend a position on the following question: Does radical org ...

Company x is currently considering a project that will

Company X is currently considering a project that will produce cash inflows of $9,000 a year for two years followed by $6,500 a year for three more years. The cost of the project is $25,000. What is the profitability ind ...

According to an article in the wall street journal in june

According to an article in the Wall Street Journal in June 2010, "Treasurys should continue to benefit from the flight-to-safety bid that caught hold this spring on concerns about debt-laden euro-zone nations and the hea ...

1 how might you find information about measures that have

1. How might you find information about measures that have been developed by ofllerresearchers? 2. What are diary mefllodologies, and why are flley used? 3. Discuss ways in which interviewers can increase flle reliabilit ...

1 what is the scientific method and how does it guide

1. What is the scientific method, and how does it guide research? 2. Discuss the basic characteristics of scientific inquiry (empiricism, objectivity, and accumulation) and their value to science. 3. In what ways is scie ...

In 2013 the lissa company paid dividends of 10000000 on

In 2013, the Lissa Company paid dividends of $10,000,000 on after-tax income (cash flow) of $25,000,000. Capital budget projects totaled $15,000,000 in 2013.   2013 was a normal year for earnings, dividends, and capital ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen