1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
algol13
2 years ago
14

Suppose that a lumberyard has a supply of 10-ft boards, which are cut into 3-ft, 4-ft, and 5-ft boards according to customer dem

and. The 10-ft boards can be cut into several sensible patterns. each in such a way that there the leftover material is less than 3-ft. The lumberyard just received an order for 90 3-ft boards, 60 4-ft boards. and 60 5-ft boards. a. Determine all sensible patterns the lumberyard may use to cut the 10-ft boards.b. The lumberyard would like to use as few 10-ft boards as possible in meeting the demand. Write out a mathematical formulation for the problem as an integer linear program ILP), and setup/solve this problem using Microsoft Excel solver. What is the optimal number of each pattern, and what is the minimum number of boards to cut?

Business
2 answers:
Alja [10]2 years ago
7 0

Answer :

Some answers are attached below

Explanation:

a) Based on the information provided, below are the all possible sensible patterns the lumberyard may use to cut the 10-ft boards -

Pattern Number 3-ft boards 4-ft boards 5-ft boards Waste (<3-ft)

1                      3                   0                     0                       1                                                                        

2                                2                 1                          0                      0

3                             1                    0                           1                       2            

4                                 0                     1                          1                        1

5                           0                      2                           0                       2                  

6                      0                     0                            2                     0      

b) ILP Formulation

Objective Function

Minimize Number of 10 ft-boards to be cut

Z = x1+x2+x3+x4+x5+x6 where xi is the number of boards for pattern i

subject to constraints -

3x1+2x2+x3>=90 ----> 3-ft boards

x2+x4+2x5>=60 ----->4-ft boards

x3+x4+2x6>=60 ----->5-ft boards

Xi>=0 ---->Non-negativity constraint

Below is the excel solver formulation and solution -

The optimal number of Pattern 1,5,6 =0, Pattern 2,3 and 4 = 30

The minimum number of 10 ft-boards to be cut = 90

Sonja [21]2 years ago
4 0

Answer:

Explanation:

please find the answer in the attached

Download docx
You might be interested in
Bean​ Brewers, Inc., a manufacturer of coffee​ makers, had the following​ activities, allocated​ costs, and allocation​ bases: A
aivan3 [116]

Answer: B. $438

Explanation:

Correspondence Cost = Number of letters * Predetermined cost of correspondence  

Predetermined cost of correspondence = Allocated cost/ Allocated base

= 14,000/1,600 letters

= $8.75 per letter

Northeast Office used 50 letters for correspondence.

Cost = 8.75 * 50

= $437.50

= $438

4 0
3 years ago
Homer wants to borrow money from the springfield bank to buy a trampoline. The bank requires collateral for loan what is collate
Minchanka [31]

Answer:

Collateral is a downpayment for the loan

Explanation:

Collateral is basically saying I'll give you what I have right now for this and when I get on my feet ill be able to pay you back then

5 0
3 years ago
The primary goal of the consumer financial protection bureau is
ASHA 777 [7]
The Consumer Financial Protection Bureau (CFPB) is not well-known to many people. It’s a relatively new government organization that’s part of the Federal Reserve. The CFPB was created after the financial crisis<span> of 2008 to protect consumers – hence the name. Before the CFPB was created, the responsibility to protect consumers was divvied up among several government agencies. But consumer protection is the CFPB’s primary focus. </span>
7 0
2 years ago
Read 2 more answers
Neon Light Company of Kansas City ships lamps and lighting appliances throughout the country. Ms. Neon has determined that throu
FromTheMoon [43]

Answer:

A. $7,275,000

B. $436,500

C. YES

Explanation:

A. Calculation for how many dollars will the cash management system free up

First step is to calculate for Additional collections

Using this formula

Additional collections=Daily collections× Numbers of days to speed up

Let plug in the formula

Additional collections= $2,250,000 million per day × 3 days speed up

Additional collections=$6,750,000

Second step is to calculate for delayed disbursements using this formula

Delayed disbursements= Daily disbursement × Numbers of Days for slow down

Let plug in the formula

Delayed disbursements= $1,050,000 million per day ×0.5

Delayed disbursements= 525,000

Last step is to calculate for the freed up fund using this formula

Freed up fund=Additional collections+Delayed disbursements

Let plug in the formula

Freed up fund=$6,750,000 + 525,000

Freed up fund=$7,275,000

Therefore the amount of dollars that the cash management system will free up is $7,275,000

B. Calculation for how much will the income be using this formula

Income =Freed up fund× Interest rate

Let plug in the formula

Income=$7,275,000×6%

Income=$436,500

Therefore the income amount will be $436,500

C. YES it should be implemented reason be that the income amount of $436,500 is $36,500 ($435,600- $400,000) higher than New system total cost of the amount of $400,000

3 0
2 years ago
Jose is an up and coming entrepreneur working on solidifying his business plans. After meeting with his mentor, he learns that h
dybincka [34]

Answer:

This is important for Jose because as a business owner you want to know what type of business you are running

Explanation:

hope this helps :D

4 0
2 years ago
Other questions:
  • The five dollar Burger Joint gift card that your friend gave you for your birthday expires today. You can either use the gift ca
    10·1 answer
  • Gammil companyhas beginning and ending raw materials inventories of $96000 and $120000, respectively. if direct materials used w
    9·1 answer
  • Magpie Corporation uses the total cost concept of product pricing. Below is cost information for the production and sale of 60,0
    12·1 answer
  • Salvia Company recently purchased a truck. The price negotiated with the dealer was $40,500. Salvia also paid sales tax of $2,10
    7·2 answers
  • What is a purpose of having a conceptual framework?
    6·1 answer
  • Kenneth purchased a car from his local dealership, Quartent Cars. However, since the car was not available in the color that Ken
    5·1 answer
  • A product is considered to be rivalrous if your consumption of the product reduces the quantity available for others to consume.
    11·2 answers
  • Kansas Enterprises purchased equipment for $74,500 on January 1, 2021. The equipment is expected to have a ten-year service life
    9·1 answer
  • The large percentage of population involved in agriculture in China indicates that most people consume an inadequate number of c
    5·1 answer
  • For the month of June, Beeman Corp. estimated sales revenue at $600,000. Beeman pays sales commissions that are 4% of sales reve
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!