The function f takes number of weeks since a factory was opened and gives number of operational factory lines, g takes number of weeks since a factory was opened and gives total number of items the factory needs to produce. Combine these so that C takes number of weeks since a factory was opened and gives how many items per line must be produced

The function f takes number of weeks since a factory was opened and gives number of operational factory lines, g takes number of weeks since a factory was opened and gives total number of items the factory needs to produce. Combine these so that C takes number of weeks since a factory was opened and gives how many items per line must be produced

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter3: Working With Large Worksheets, Charting, And What-if Analysis

Section: Chapter Questions

Problem 2.2EYK

See similar textbooks

Similar questions

Find the minimum product of sums for the following function. Each drop down menu has a number of choices. You must select an answer from each drop down menu. The choices include possible terms in the function. Another choice is "none", and should be used when none of the terms from that drop down menu are needed for the minimum solution. Finally, the choice "two or more" should be selected if more than one of the possible terms appearing in that drop down menu are required for the solution. There are too many possible 3 and 4 literal terms for automatic checking, so just select how many of them are required. f(a,b,c,d) = m(0, 1, 2, 4, 5, 6, 12, 13) + Σd(8, 14) Terms involving a and b: [Select] Terms involving a and c: [Select] Terms involving a and d: [Select] Terms involving b and c: [Select] Terms involving b and d: [Select] Terms involving c and d: [Select] Terms involving 3 literals: [Select] Terms involving 4 literals: [Select] > >
Write a function that takes three arguments to represent the number of threshold, typical and excellent SOBs obtained by a student for each category, i.e. the first argument will represent the number of threshold SOBs that has been observed for given a student, the second argument will represent the number of typical SOBs that has been observed, and the third argument will represent the number of excellent SOBs that has been observed. There are overall 35 Threshold, 51 Typical and 31 Excellent SOBs (a total of 117).If the student has passed, i.e. all 35 threshold SOBs are observed, the function returns the number of SOBs completed as a percentage. E.g. if the function is called computeFinal and it is called with thefollowing values/inputs (computeFinal 35 11 6), whereby the first argument represents threshold SOBs, the second typical and the third excellent, then the function returns 44.44 (representing the percentage of SOBs completed). If the student has not got all 35 threshold…
A store has issued two different coupons for its customers to use. One coupon gives customers $25 off their purchase price, and the other coupon gives customers 30% off of their purchase. The store allows customers to use both coupons and choose which coupon to apply first. For this context, ignore sales tax. Let D be the function that inputs a cost (in dollars) and outputs the cost after applying the "$25 off" coupon, and let P be the function that inputs a cost (in dollars) and outputs the cost after applying the "30% off" coupon. 1.A customer purchases an item for $140 and asks the cashier to apply the "$25 off" coupon first, followed by the "30% off" coupon. Use function notation to represent the cost of the item (in dollars) after the two coupons are applied. 2.A customer purchases an item for $140 and asks the cashier to apply the "30% off" coupon first, followed by the "$25 off" coupon. Use function notation to represent the cost of the item (in dollars) after the two…
Write a function prime() that returns 1 if its argument is a prime number and returns 0 otherwise.
a function should convert a from the function a Fahrenheit temperatures (F) to a Celsius temperatures . what should be the out put from the function? F and C, F and 32 , F only, C only
Using a relevant example, explain how a function works.
A store has issued two different coupons for its customers to use. One coupon gives customers $25 off their purchase price, and the other coupon gives customers 20% off of their purchase. The store allows customers to use both coupons and choose which coupon to apply first. For this context, ignore sales tax. Let f be the function that inputs a cost (in dollars) and outputs the cost after applying the "$25 off" coupon, and let g be the function that inputs a cost (in dollars) and outputs the cost after applying the "20% off" coupon. A customer purchases an item for $130 and asks the cashier to apply the "$25 off" coupon first, followed by the "20% off" coupon. What is the cost of the item after the two coupons are applied?
Write the definition of a function that takes as input three numbers. The function returns true if the floor of the product of the first two numbers equals the floor of the third number; otherwise it returns false. (Assume that the three numbers are of type double.)
Write a function that implements the quadratic equation. Given three inputs (a, b, and c), calculate the roots (r1 (+) and r2 (-)) of the quadratic formula. Review 19 Write a function that implements the quadratic equation. Given three inputs (a, b, and c), calculate the roots (r1 and r2) of the quadratic formula. Call your function Roots a = 1 b = 2 c = -3 [r1,r2]=Roots(a,b,c)
Create a function that returns the simplified version of a fraction. Examples simplify ("4/6") simplify("10/11") "10/11" simplify("100/400") "1/4" simplify("8/4") → "2" → "2/3" Notes • A fraction is simplified if there are no common factors (except 1) between the numerator and the denominator. For example, 4/6 is not simplified, since 4 and 6 both share 2 as a factor. • If improper fractions can be transformed into integers, do so in your code (see example #4).
Write a program that inputs a number for day of the week (e.g. 1 for Monday, 2 for Tuesday, …, 7 for Friday). The program should print the name of the day and if the user enters a week day, call a function weekday() that prints the schedule for a week day, otherwise call a function weekend() to print the schedule for a weekend day. The functions weekday() and weekend() takes no parameters and returns no value. Sample output1: Enter a day number (e.g.1(Monday), 2(Tuesday)) to display schedule:6 Saturday. Go for a walk. Hang out with friends. Do house chores.
(Numerical) Heron’s formula for the area, A, of a triangle with sides of length a, b, and c is A=s(sa)(sb)(sc) where s=(a+b+c)2 Write, test, and execute a function that accepts the values of a, b, and c as parameters from a calling function, and then calculates the values of sand[s(sa)(sb)(sc)]. If this quantity is positive, the function calculates A. If the quantity is negative, a, b, and c do not form a triangle, and the function should set A=1. The value of A should be returned by the function.