Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory, selling price, and Bill of Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built to maximize revenue. You must make 4 chairs for every table. Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number.) Scenario 1 Large wood per table 3 Small wood per table 2 Large wood per chair 1 Small wood per chair 4 Revenue per table $35 Revenue per chair $29 Large wood inventory 300 Small wood inventory 500
Q: A company is considering two insurance plans with coverage and premiums shown in the table. (For…
A: NOTE: As you have posted multiple questions, the first question is solved as per guidelines. You are…
Q: A company produces and sells luxury goods and is able to control the demand for the product by…
A: A company produces and sells luxury goods and can control the demand for the product by varying the…
Q: SureStep is currently getting 160 regular-time hours from each worker per month. This is actually…
A: Productivity and complete output standards are met in an organization where the workers work with…
Q: In the Walton Bookstore example with a discretedemand distribution, explain why an order…
A: For the above question, we can assume that a fixed set of demands are given. Let the order quantity…
Q: An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV…
A: Given data is Medium Cost Reached Quality TV 500 10000 30 Radio 200 3000 40 Newspaper 400…
Q: A sporting goods store sells footballs, basketballs, and volleyballs. A football costs $7, a…
A: Given Information: Cost of a football = $ 7 Cost of a basketball = $ 15 Cost of a volleyball = $…
Q: Teacher Required Penalty History 35 $26,000 Science 30 $30,000 Math 40 $28,000 English 32 $24,000
A: Formulate Goal programming (GP) model as mentioned below- Decision variables: Let x1, x2, x3, x4,…
Q: nformation on a business is given below. Variable Expenses: Raw material expense: 250 TL / piece…
A: Answer: a. Sum total of variable expense or variable cost: 250+150+100+75+125 = 700 TL and sum total…
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A:
Q: How many units of each type should the firm buy in order to maximize total return?
A: The given problem is: Maximize z=400x+800y Subject to x2+y2−4x−6y=67 Using Lagrange multipliers,
Q: The aim of the objective function for Chris Beehner Company should be to the objective value.…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: A firm wants to determine its production rate over the next twelve months. expected demand for its…
A: Decision Variable: Suppose Pi = Production in month-i for i=1,2,3...,12 Si = Shortage in month-i…
Q: A company is considering two insurance plans with the following types of coverage and premiums Plan…
A: Given that: Total coverage for fire/theft insurance = $6,36,000 Total coverage for liability…
Q: A large sporting goods store is placing an order for bicycles with its supplier. Four models can…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: strategy that maximizes the department store chain's expected profit earned by purchasing and…
A: πij= Revenue from regular price +Revenue from closeoutprice-cost of purchase =…
Q: A market analyst working for a small appliance manufacturer finds that if the firm produces and…
A: Answer (a) When given a graph of a profit equation with the number of items produced on the x-axis…
Q: A firm is considering importing some products to sell in a local market. The unit price and cost for…
A:
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A: Maximize: 1.50A + 1.20G Subject to: Sugar: 1.5A + 2.0G£ 1,200 cups Flour: 3.0A + 3.0G£ 2,100 cups…
Q: The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each…
A: The LP modelThe decision variables are the number of double beds (D) and twin beds (T).The…
Q: A large sporting goods store is placing an order for bicycles with its supplier. Four models can be…
A: Linear programming or LP is one of the most simplistic methods to achieve optimization. It assists…
Q: A person sells and installs A, B and C. The table shows, for example, that it takes 3 hours to sell…
A: Product No. of Units Selling Hours per Unit Installation Hours per Unit Profit per Unit A x 1 1…
Q: A buyer for a large department store chain must place orders with an athletic shoe manufacturer six…
A: Given, Cost Price = $65 Selling Price = $85 Closeout sell price = $55 Demand (100s of pairs)…
Q: A bond has a face value of $1,000, an annual coupon rate of 3.70%, an yield to maturity of 7.4%,…
A: MACAULAY DURATION Using analytic…
Q: Your company orders packs of gums and, then, sells them to retailers. The profit you get from each…
A: A payoff matrix is a table where techniques of one player are recorded in lines and those of the…
Q: Spein Company is a diversified company that discloses supplemental financial information on its…
A: Company's given financial data- Segment Sales Traceable Costs Allocable Costs Segment X…
Q: A company needs to schedule the monthly production of a certain item for the next 4 months. The unit…
A: Given data, Production cost estimated for the first 2 month = $12 For the last 2 month = $14…
Q: In a capital budgeting problem, a decision maker having a limited amount of budget is considering to…
A: If Project C is not chosen, Then Projects A and B must be chosen
Q: The cost per day of running a hospital is 200,000 +0.5x2 dollars, where x is the number of patients…
A: Given: 1. Cost per day for the hospital is of the form 200,000+0.5x² patients where x is the number…
Q: JJ owns a company that makes candles. The three most popular candles are created using a combination…
A: X1=Number of Citrus Burst CandlesX2=Number of Lemon Cookie CandlesX3=Number of Floral Breeze Candles
Q: The owner of a snack food business wants to create two nut mixes for the holiday season. The regular…
A: Decision variable: Suppose-R be the no. of regular nut mixD be the no. of delux nut mix
Q: If the profit generated per cabinet is P80 and per dresser is P100, write the objecti that best…
A: Linear programming is a process to reach the best outcome such as maximum profit or lowest cost in a…
Q: The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each…
A: Answer:Introduction:The given problem is solved using linear programming. The given problem is…
Q: What is the optimized net cost? $ b. Use SolverTable to see what happens to the decision…
A: SOLUTION IS AS BELOW:
Q: Based on Zangwill (1992). Murray Manufacturingruns a day shift and a night shift. Regardless of…
A: Given information, cost = 8000 Night shift = 45000 Demand Day 1 - 2000 Night 1 = 3000 Day 2 =…
Q: Solve this problem in three ways; 1. Graphical 2. Excel solver 3. Sensitivity analysis/ report. a)…
A: Note: - Since we can only answer only up to three subparts and also it is not specified which…
Q: Hello, Below is the question from Statistic Chapter Linear Programming and the solution is required…
A: Following is the excel model:
Q: ailco Corporation must determine how many sailboats should be produced during eachof the next four…
A: Given: Demand for sailboats in each quarter: First-quarter – 40 sailboats Second-quarter – 60…
Q: Consider the Answer and Sensitivity Reports at the end of the questionnaire to answer the following…
A: What are the constraint quantity values? Referring the constraints table in the sensitivity report:…
Q: FORUM Furniture buys two products for resale: big shelves (B) and medium shelves (M). Each big shelf…
A: B = Number of Big shelves M = Number of Medium shelves Objective function: Maximize Z = 360B + 250M…
Q: If a company currently has $1000 cash, $300 income every month and $200 profit every month, how many…
A: Given that: Cash in Hand = $1000 Income(Revenue) =$300 Profit = $200
Q: A Make-or-Buy DecisionTriple X Company manufactures and sells refrigerators. It makes some of the…
A: If part has been manufactured: Fixed cost: $50,000 Labor cost: $1,25,000 Factory overhead: $60,000…
Q: company operates a farm on which sheep are raised. The farm manager has determined that for the…
A:
Q: You have a new job as a Financial Planning assistant. Your client wants to invest money in stocks,…
A: S = Total dollars invested in stocks B = Total dollars invested in Bonds T = Total dollars invested…
Q: LEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components…
A: Let us assume x1 as the no.of components of A to be produced, x2 for B and x3 for C. It is also…
Q: A company produces three types of items. A singlemachine is used to produce the three items on a…
A:
Q: Answer the following true or false.a. The lead time is always less than the cycle time.b. The…
A: Note:- We are authorized to answer one question at a time, since you have not mentioned which…
Q: Each well that is drilled produces both natural gas and oil. Based on current information, each MCF1…
A: As , Given the cost of well = 1500000 Cost of leasing land= 1800000 Labor & Miscellaneous cost=…
Q: A gas company owns two refineries, 32 LPG bottling plants, and 367 retail outlets. The company has…
A: Performance management is a tool that enables the evaluation of the quality and efficiency of the…
Q: a. Formulate a linear programming model that can be used to determine the number of gallons of…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory, selling price, and Bill of Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built to maximize revenue. You must make 4 chairs for every table.
Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number.)
Scenario 1 | |
Large wood per table | 3 |
Small wood per table | 2 |
Large wood per chair | 1 |
Small wood per chair | 4 |
Revenue per table | $35 |
Revenue per chair | $29 |
Large wood inventory | 300 |
Small wood inventory | 500 |
Let us assume x1 is the no of tables to be made
and x2 as the number of chairs to be made
Now, Arrange the given data into excel as shown below:
Enter the following parameters into SOLVER dialog box:
Final answer will be as follows:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
- As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. Make the following assumptions: You will charge $600 per person for a two-day class. You estimate that 30 people will attend the class, but you want to change this input. Your fixed costs include $500 total to rent a room for both days, setup fees of $400 for registration, and $300 for designing a postcard for advertising. Youwill not include your labor costs for this estimate, but you estimate that you will spend at least 150 hours developing materials, managing the project, and giving the actual class. You would like to know what your time is worth given different scenarios. Youwill order 5,000 postcards, mail 4,000, and distribute the rest to friends and colleagues. Yourvariable costs include the following: $5perperson for registration plus 4 percent of the class fee per person to handle credit card processing; assume that everyone pays…you own a furniture store and you are in the process of planning the production of wooden chairs for the next six months. your demand forecast for wooden chairs for the next six months is 150,100,200,300,50,200. you currently stock 50 chairs in stock. one of your customers informed you that they would be returning 50 additional chairs to you and you expect to receive these returns in month 2. you currently employ 10 skilled employees who work entirely making chairs. in the last six months they were able to make 900 chairs working full time. you are considering two alternative production plans: constant workforce level for the next six months and meet all demand on time. adjust your workforce level only once over the next six months after month 0. ( no still backlogging). hiring cost per employee=$1000holding cost monthly per chair=$10 lay off cost per emloyee=$2000payroll cost monthly per employee=$2000 implement each alternative to obtain the least total cost. solve this question…
- you own a furniture store and you are in the process of planning the production of wooden chairs for the next six months. your demand forecast for wooden chairs for the next six months is 150,100,200,300,50,200. you currently stock 50 chairs in stock. one of your customers informed you that they would be returning 50 additional chairs to you and you expect to receive these returns in month 2. you currently employ 10 skilled employees who work entirely making chairs. in the last six months they were able to make 900 chairs working full time. you are considering two alternative production plans: constant workforce level for the next six months and meet all demand on time. adjust your workforce level only once over the next six months after month 0. ( no still backlogging). hiring cost per employee=$1000holding cost monthly per chair=$10 lay off cost per emloyee=$2000payroll cost monthly per employee=$2000 implement each alternative to obtain the least total cost. solve this question with…Choose the correct letter of answer If your objective is to maximize the profit for products x and y which earns a contribution margin of P2 and P3 respectively, your objective function must be: *a. P = 3x + 2yb. P = 2x + 3yc. P = x + y d. none of the aboveXYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes one hour to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
- Answer the following questions. Make sure to number your answers when you upload your response. Suppose Alphonso’s town raised the price of bus tickets to $2.50 per trip (while the price of burgers stayed at $3.50 and his budget remained $11.50 per week.) Draw Alphonso’s new budget constraint. What happens to the opportunity cost of bus tickets? Suppose Alphonso’s town raises the price of bus tickets from $2.50 to $5 and the price of burgers rises from $3.50 to $7. Why is the opportunity cost of bus tickets unchanged? Suppose Alphonso’s weekly spending money increases from $11.50 to $23. How is his budget constraint affected from all three changes? Explain. Use this information to answer the following 4 questions: Marie has a weekly budget of $24, which she likes to spend on magazines and pies. If the price of a magazine is $4 each, what is the maximum number of magazines she could buy in a week? If the price of a pie is $12, what is the maximum number of pies she could buy in a…XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?Dark beer is purchased by the case for $18.90. There are 24 bottles in each case, and each bottle contains 12 fluid ounces. You are making brine that requires 2 ½ quarts of dark beer. How much will the beer cost for the brine?
- Engr. Puhon is selling bicycle spare parts in the neighborhood. As he is trying to fill out the orders for the bicycle tires, he is uncertain on what the sales will be. He had table below showing the profits given a certain sales and buying level combinations. With an index of realism equal to 0.40, how many should he buy? Actions Buy 30 P25,000 75,000 75,000 Weekly Sales Buy 20 P50,000 50,000 50,000 Buy 40 PO 50,000 100,000 20 30 40 Select one: O Buy 40 O Buy 30 O Buy 35 O Buy 20Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25An airline studied the data from their passenger records and noted that their customers turn up only about 95% of the time. A flight can accommodate 40 passengers and each seat costs 4,000 Php. Suppose each passenger books a ticket independently and the airline decides to sell 42 tickets for the flight. If more than 40 show up for the flight , then the extra passengers will be compensated PhP10,000 for rebooking and other expenses. 5. If Profit = Ticket sales-Compensation of Bumped passenger(s). What is the profit if 42 customers show up?