Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

This is my school homework, Study notes of Marketing Business-to-business (B2B)

This is my school homeworkThis is my school homework

Typology: Study notes

2024/2025

Uploaded on 05/14/2025

kineesh-jackson
kineesh-jackson 🇺🇸

5 documents

1 / 74

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 5/6/2025 4:43:18 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.016 Seconds.
Iterations: 3 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance %, Assume NonNegative
Objective Cell (Max)
Cell Name Original Value Final Value
$B$15 Total Profit Small 0 1092
Variable Cells
Cell Name Original Value Final Value
$B$12 Number to make Small 0 30
$C$12 Number to make Medium 0 29
$D$12 Number to make Large 0 25
Constraints
Cell Name Cell Value Formula
$B$20 Beads Used/Produced 1542 $B$20<=$D$20
$B$21 Thread (inches) Used/Produced 356 $B$21<=$D$21
$B$22 Glue (ounces Used/Produced 22 $B$22<=$D$22
$B$23 Min Small Production Used/Produced 30 $B$23>=$D$23
$B$24 Max Large Production Used/Produced 25 $B$24<=$D$24
$B$12 Number to make Small 30 $B$12>=0
$C$12 Number to make Medium 29 $C$12>=0
$D$12 Number to make Large 25 $D$12>=0
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34
pf35
pf36
pf37
pf38
pf39
pf3a
pf3b
pf3c
pf3d
pf3e
pf3f
pf40
pf41
pf42
pf43
pf44
pf45
pf46
pf47
pf48
pf49
pf4a

Partial preview of the text

Download This is my school homework and more Study notes Marketing Business-to-business (B2B) in PDF only on Docsity!

Microsoft Excel 16.0 Answer Report Worksheet: [Book1]Sheet Report Created: 5/6/2025 4:43:18 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance %, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $B$15 Total Profit Small 0 1092 Variable Cells Cell Name Original Value Final Value $B$12 Number to make Small 0 30 $C$12 Number to make Medium 0 29 $D$12 Number to make Large 0 25 Constraints Cell Name Cell Value Formula $B$20 Beads Used/Produced 1542 $B$20<=$D$ $B$21 Thread (inches) Used/Produced 356 $B$21<=$D$ $B$22 Glue (ounces Used/Produced 22 $B$22<=$D$ $B$23 Min Small Production Used/Produced 30 $B$23>=$D$ $B$24 Max Large Production Used/Produced 25 $B$24<=$D$ $B$12 Number to make Small 30 $B$12>= $C$12 Number to make Medium 29 $C$12>= $D$12 Number to make Large 25 $D$12>=

ns are satisfied. nce %, Assume NonNegative Integer Contin Contin Contin Status Slack Not Binding 258 Not Binding 124 Binding 0 Binding 0 Binding 0 Not Binding 30 Not Binding 29 Not Binding 25

Allowable Allowable Increase Decrease 2.4 1E+ 0.5714285714 3 1E+030 0. Allowable Allowable Increase Decrease 1E+030 258 1E+030 124 3.5833333333 7.25 <- since the shadow price is positive, that means the dollar amount th 36.25 30 20.714285714 25

means the dollar amount the company can save is 52 or every additional unit added to the right hand side

Input Data Item Small Medium Large Profit Per Unit 8 13 19 Bead (each) 14 18 24 Thread (inch) 3 4 6 Glue (ounce) 0.2 0.25 0. Decision Variables Small Medium Large Number to make 30 29 25 <-- the cells solver will change Objective Function Total Profit 1092 Constraints Resource Used/Produced Sign Available/Limit Beads 1542 <= 1800 Thread (inches) 356 <= 480 Glue (ounces 22 <= 22 Min Small Productio 30 >= 30 Max Large Productio 25 <= 25

ells solver will change)