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

Assignment exploring the sec 10-kwe are going to explore

Assignment: Exploring the SEC 10-K We are going to explore our company's SEC-10K. For most, if not all classmates, this will be the first time you have ever seen or read this type of report. Note: the SEC 10-K is an audi ...

How would a relatively high home inflation rate affect the

How would a relatively high home inflation rate affect the home country's current account, all other thing being equal? How would you expect a weakening home currency to affect the home country's current account, all oth ...

Consider the following analysis the rise and fall of a

Consider the following analysis: The rise and fall of a bond's price has a direct inverse relationship to its yield to maturity, or interest rate. As prices go up, the yield declines and vice versa. For example, a $1,000 ...

At your discount brokerage firm it costs 995 per stock

At your discount brokerage firm, it costs $9.95 per stock trade. How much money do you need to buy 100 shares of Ralph Lauren (RL), which trades at $85.13?

You have a 1100 balance on your 15 credit card you have

You have a $1,100 balance on your 15% credit card. You have lost your job and been unemployed for 6 months. You have been unable to make any payments on your balance. However, you received a tax refund and want to pay of ...

Sorenson inc has sales of 5119000 a gross profit margin of

Sorenson Inc. has sales of $5,119,000, a gross profit margin of 32.18 percent, and inventory of $1,017,000. What are the company's inventory turnover ratio and days' sales in inventory?

You have the following information on universe it ts inc

You have the following information on Universe It Ts, Inc.: sales to working capital = 19 times, profit margin = 26.9%, net income available to common stockholders = $4.9 million, and current liabilities = $1.9 million. ...

1 what is a factorial design why are factorial designs used

1. What is a factorial design? Why are factorial designs used more frequently than one-way designs? 2. How many independent variables are involved in a 3 x 3 factorial design? How many levels are there of each variable? ...

Comprehensive problemuse what you have learned about the

Comprehensive Problem Use what you have learned about the time value of money to analyze each of the following decisions: Decision #1: Which set of Cash Flows is worth more now? Assume that your grandmother wants to give ...

1 what is the equation of exchange is the equation of

1. What is the equation of exchange? Is the equation of exchange a theory? Briefly explain. 2. What is the quantity theory of money? What does the quantity theory indicate is the cause of inflation? 3. What is purchasing ...

  • 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