Answered: Use spreadsheet software to use… | bartleby

Practical Management Science

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 56P

See similar textbooks

Related questions

Question

Please avoid solutions image format thanks

[The following information applies to the questions displayed below.)
Felix & Company reports the following information.
Period
1
2
5
6
7
a
9
10
Units Produced
0
Cost equation
520
920
1,320
1,720
2,120
2,520
2,920
3,320
3,720
Total Costs
$ 4,620
3,920
4,320
4,920
4,020
4,220
8,720
16,120
4,920
11,502
Use spreadsheet software to use ordinary least-squares regression to estimate the cost equation, including fixed and variable cost
amounts.
per unit

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
Campbell’s Wholesale Company is preparing monthly cash budgets for the fourth quarter of theyear. Monthly sales revenue in this quarter is estimated as follows: October, $30,000; November,$24,000; and December, $20,000. All sales are made on open credit with 70% collected in themonth of sale and 30% collected in the following month. What is the estimated total cash collectedin November? December?
Grey Manufacturing Company expects sales to total 13,000 units in the first quarter, 12,000 units inthe second quarter, and 15,000 units in the third quarter of the current fiscal year. Company policyis to have on hand at the end of each quarter an amount of inventory equal to 10% of the followingquarter’s sales. Given this information, how many units should be scheduled for production in thesecond quarter?
2. If the projected or forecasted sales of Malinao Bakery for the month of Januaryis 2100 loaves of bread, beginning inventory 50 loaves and the selling price isP50 per loaves. How much are the projected sales in peso of Malinao Bakeryfor January?A. P100,000. C. P107,500.B. P100,500. D. P105,000.
6) Nicole has decided to go to school which costs her a total of P19,500 and give upi on a job that paid her P24,900 for the year. But instead, she can hope to earn P29,900 after she graduates. Nicole's opportunity cost amount to?a. P19,500 b. P24,900c. P29,900d. P5,000 7. Villanueva Enterprises reported the ff. information. What is the cost of goods manufactured in February?I. Jan. 2017 -job accumulated cost of P3,000ii. Feb. 2017 -the following costs were added to production: Job 1-P10,000 Job 2-P8,000Job 3-P7,000 III. Feb. 2017 Job 1 was completed and sold for P18,000 Job 2 was completed but not sold Job 3 remains in production b. P8,000c. P10,000 d. P13,000e. P21,000 8. Julie borrowed a certain amount from Diane on June 2016. Two years later, Julle i again borrowed P5,000. Julie decided to pay P1,000 on June 2019 and dischargei her balance by paying P7,500 on June 2021. What was the amount borrowed oni June 2016 if the interest rate is 8% compounded annually?a. P1,389.50 b.…
SIMPLEX METHOD: Min C = 3X1 + 7X2 + 5X3 Subject to: X1 + X2 + X3 > 50 2X1 + 3X2 + X3 > 100 Based on the initial tableau, answer questions no. 1-5 What is the value of X3 on the Cj row? What is the value of S2 on the right-hand side/quantity column? What is the value of Zj on the right-hand side/quantity column? What is the value of X3 on the Cj – Zj row? What is the entering variable?
West Company’s contribution format income statement for March 2020 is givenbelow:Sales (15,000 units X $30 per unit) $450,000Variable expenses 315,000Contribution margin 135,000Fixed expenses 90,000Net operating income $ 45,000The industry in which West Company operates is quite sensitive to regularmovements in the economy. Thus, profits vary considerably from year to yearaccording to general economic conditions. The company has a large amount ofunused capacity and is studying ways of improving profits.Required:The company CEO has asked you as a Senior Manager to evaluate the belowsituations with recommendations:1- New equipment has come onto the market that would allow WestCompany to automate a portion of its operations. Variable expenseswould be reduced by $9 per unit. However, fixed expenses wouldincrease to a total of $225,000 each month. How Net Income wouldappear if the new equipment were purchased. As a Senior Manager,what factor/s would be paramount in your mind deciding…
The below is an extract from the fixed asset register of ABC Ltd as at 31 December 2019Date of PurchaseCostuseful lifeLand1-Jan-306,000,000.000Building28-Feb-172,000,000.0020Vehicle:650,000.00Toyota Hilux1-Oct-19 350,000.005Ford Ranger30-Jun-17 300,000.005Furniture and Fittings1-May-20150,000.002Activities throughout the 2020 Financial Period:1. New Machinery have been purchased on 01 April 2020 at a Cost of N$ 4000,000. The machinery has been installed on the 15 April 2020 and was available for use on the 01 May 2020. Machinery is the only property plant and equipment of the company that is measured according to the revaluation method.1.1. On the 30th of October 2020 management decided to revalue the machinery due to a drastic decline in the revenue from sale of machinery produced inventory.Net replacement cost for the machine as at the 30th of October 2020 is N$2 000 000.2. The Toyota Hilux was involved in an accident on 1 October 2020 due to the floods and was written off by the…
19. What combination of x and y will yield the optimum for this problem? Maximize $3x + $15y, subject to (1) 2x + 3y ≤ 12 and (2) 5x + 2y ≤ 10 and (3) x, y ≥ 0. Part 2 A. x = 0, y = 3 B. x = 2, y = 0 C. x = 0, y = 0 D. x = 0, y = 4 E. x = 1, y = 5
Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 5 2 1E+30 $B$3 Product_2 175 0 7 1E+30 1 $B$4 Product_3 0 −1.5 9 1.5 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 If the objective function coefficient for Product_1 were increased to a value of 8, which of the following would be TRUE? The optimal solution would change. The optimal objective function value would stay the same. Product_1 would enter the solution (the final value of the variable Product_1 would be greater than zero).
Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 5 2 1E+30 $B$3 Product_2 175 0 7 1E+30 1 $B$4 Product_3 0 −1.5 9 1.5 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 If the right-hand side of Resource_C increases to 750, which of the following would be true The objective function value will increase by $1.75 The objective function value will decrease by $1.75 The objective function value will increase by $87.50 The objective function value will decrease by $87.50 None of the answer choices is correct
Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 5 2 1E+30 $B$3 Product_2 175 0 7 1E+30 1 $B$4 Product_3 0 −1.5 9 1.5 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 If the objective function coefficient for Product_1 were decreased to a value of 3, which of the following would be TRUE? The optimal solution would change. The optimal objective function value would stay the same. Product_1 would enter the solution (the final value of the variable Product_1 would be greater than zero). A. 1 only B. 2 only C. 3 only D. 1, 2 and 3 E. Only 1 and 2

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS