subject
Business, 06.03.2020 09:47 daebreonnakelly

Material 1 costs $7 a pound, material 2 costs $5 a pound, and labor costs $15 per hour. Product A sells for $101 a unit, product B sells for $67 a unit, and product C sells for $97.50 a unit. Each week there are 300 pounds of material 1; 400 pounds of material 2; and 200 hours of labor. Also, there is a weekly demand of at least 10 units of product C each week. Formulate the given problem scenario as a linear program, and solve the problem using Microsoft Excel Solver. For the formulation, provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem as completely as possible. Also, the Excel set-up should provide clearly labeled values used for the decision variables, constraints, and objective function.

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 21:30
Problem 2-18 job-order costing for a service company [lo2-1, lo2-2, lo2-3]speedy auto repairs uses a job-order costing system. the company's direct materials consist of replacement parts installed in customer vehicles, and its direct labor consists of the mechanics' hourly wages. speedy's overhead costs include various items, such as the shop manager's salary, depreciation of equipment, utilities, insurance, and magazine subscriptions and refreshments for the waiting room. the company applies all of its overhead costs to jobs based on direct labor-hours. at the beginning of the year, it made the following estimates: direct labor-hours required to support estimated output 10,000fixed overhead cost $ 90,000variable overhead cost per direct labor-hour $ 1.00 required: 1. compute the predetermined overhead rate.2. during the year, mr. wilkes brought in his vehicle to replace his brakes, spark plugs, and tires. the following information was available with respect to his job: direct materials $ 600direct labor cost $ 180direct labor-hours used 2 compute mr. wilkes' total job cost. 3. if speedy establishes its selling prices using a markup percentage of 30% of its total job cost, then how much would it have charged mr. wilkes?
Answers: 1
question
Business, 22.06.2019 10:00
What is the difference between an "i" statement and a "you" statement? a. the "i" statement is non-confrontational b. the "you" statement is non-confrontational c. the "i" statement is argumentative d. the "you" statement is neutral in tone select the best answer from the choices provided
Answers: 1
question
Business, 22.06.2019 16:30
En major recording acts are able to play at the stadium. if the average profit margin for a concert is $175,000, how much would the stadium clear for all of these events combined?
Answers: 3
question
Business, 22.06.2019 20:20
Direct materials (4.2 x $15) $ 63direct labor ($12 x 17.5) $210manufacturing overhead ($2.40 x 17.5) $42total job cost $ 315dougan, inc. allocates overhead based on a predetermined overhead rate of $2.40 per direct labor hour. employees are paid $12.00 per hour. job 24 requires 4.2 pounds of direct materials at a cost of $15.00 per pound. employees worked a total of 17.5 hours to complete the job. actual manufacturing overhead costs totaled $80,000 for the year for the company. how much is the cost of job 24?
Answers: 1
You know the right answer?
Material 1 costs $7 a pound, material 2 costs $5 a pound, and labor costs $15 per hour. Product A se...
Questions
question
Health, 24.07.2019 16:00