Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Will’s Welded Widgets (WWW) makes its Q Model from components R, S, and T. Component R is made from 2 units of component X and 2 unit of component Y. Component T is made from 1 unit of component V and 2 units of component Z.
Calculate the gross requirements for each of the components when the company plans to build 70 of its Q Model if you have these inventories: 70 units of component T and 110 units of component R, using the given information:
Item
Usage per Parent
Q
-
R
2
S
2
T
1
X
2
Y
2
V
1
Z
2
Q
R S T
X Y V Z
Put the answers down into the table: (If answer is zero, please enter 0, do not leave any fields blank.)
Product
Gross Requirements
Q…
A mixture of pellets is to be made containing x regular pellets, y large pellets and z extra large
pellets. Cost, weight and volume data for each type of pellet are shown in the table. Is it possible
to make mixture of 55 pellets at a cost of $0.85 if the mixture is to have 120 weight units and 130
volume units? If so, how many each type of pellet should be in the mixture?
Pellet Type
5.
Number of
Cost per Pellet in
Cents
Weight
Units per Pellet
Volume
Pellets
Units per Pellet
Regular
Large
Extra large
2
1
4
y
1
4
3
Workshape Manufacturing has two classes of distributors: JIT distributors and non-JIT distributors. The JIT distributor places small, frequent orders, and the non-JIT distributor tends to place larger, less frequent orders. Both types of distributors purchase the same product. The customer activities and costs for the previous quarter are as follows:
Activity
JIT distributors
Non-JIT distributors
Sales Orders
500
30
Sales Calls
30
30
Service Calls
200
90
Average Order Size
90
1,400
Manufacturing Cost/Unit
$50
$50
Customer Costs:
Processing Sales Orders
$160,000
Selling Goods
$155,000
Servicing Goods
$195,000
Total
$500,000
Calculate the activity rate for selling goods. (Note: Round answer to two decimal places.)
a.$2,200.50 per sales call
b.$9,400.60 per sales call
c.$3,550.66 per sales call
d.$2,583.33 per sales call
e.$4,800.40 per sales call
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Company ZWZ manufactures three products in a serial system; Product XA is manufactured in Stage 1, Product XB in Stage 2, and XC in Stage 3. Product XB has a sales potential in the market; hence, some of it can be sold at the end of Stage 2, and the remaining can be moved to Stage 3. The third stage produces Product XC, and then delivers it to customers. Two units of Product XA produced in Stage 1 are required for each unit of Product XB in Stage 2. In addition, four units of Product XB produced in Stage 2 are required for each unit of Product XC in Stage 3. Stage 1 can only use regular time; however, Stage 2 has the options of using regular time and overtime in manufacturing. On the other hand, Stage 3 has only one alternative, which is subcontracting. The pertinent data are provided below: Stage 2 Stage 1 11 No overtime No subcontracting No sales 0.07 Unit regular time cost (TL) Unit overtime cost (TL) Unit subcontracting cost (TL) Unit selling price (TL) Unit processing time (hrs)…arrow_forwardXYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?arrow_forwardXYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes one hour to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?arrow_forward
- Crane Corporation manufactures a single product. Monthly production costs incurred in the manufacturing process are shown below for the production of 3800 units. The utilities and maintenance are mixed costs. The fixed portions of theses costs are 430 and 270, respectively. Production In Units 3800 Production Costs Direct Materials 7904 Direct Labor 15124 Utilities 1798 Property Taxes 1180 Indirect Labor 4484 Supervisory salaries 2100 Maintenance 1182 Depreciation 2650 Calculate the expected costs when product is 5,300 unitsarrow_forwardA company makes parts that cost $35.00 in material and labor. 92% of the parts are produced defect free and are sold for full price at $110 each. 2% of the parts made must be scrapped. Scrap parts are sold for $8.00 each. The remaining 6% of the parts made must be reworked at a cost of $12.00 each. After rework 1% still must be scrapped and the other 5% is sold at a discounted price of $90 each. a. Draw the tree diagram showing the quality cost situation. b. Determine the earnings per part. c. Determine the cost of poor quality (COPQ). d. Determine the earnings per part and COPQ if the rework operation was shut down and the parts that required reworking were just sold for scrap instead.arrow_forwardPLEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components for computers. Component A requires 2 hours of fabrication and an hour of assembly. Component B requires 3 hours of fabrication and an hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has upto 1,000 labor-hours for fabrication, 800 labor-hours of assembly time each work. If the profit on each component A, B, and C is $7, $8, and $10 respectively, how many of each should be produced to maximize profit?arrow_forward
- You are asked to help your boss deciding who is considering whether to make or buy a part fora top most demanding product of the company.Your company can make the component for $40 per unit or buy it for $50 per unit from vendor.If the Company decides to make the component, it will require 4 hours of machine time tomake each part. The company has 2,000 hours of machine time available per month. Shouldthe company make or buy the component? How many max parts company can make?________________________________________________________________arrow_forwardCan you please fill out the main boxes in a way that can be easily deciphered??arrow_forwardKala is one of the top manufacturer of ukuleles. The manufacturer produces three different types of ukuleles. Its Concert produce $6 in profit per unit; its Soprano produce $4 in profit per unit; and its Tenor produce $8 in profit per unit. Each type of ukulele passes through three manufacturing stages as a part of the entire production process. The three process centers of modelling, curing and assembly has an available production time per day of 12 hours, 14 hours and 16 hours, respectively. To produce one hundred units of Concert, the time required for the process of modelling, curing and assembly is 2 hours, 3 hours and 2 hours, respectively. To produce one hundred units of Soprano, 2 hours of modelling, 2 hours of curing and 1 hour of assembly is required. Whereas 4 hours of modelling, 2 hours of curing and 2 hours of assembly is required to produce one hundred units of Tenor. Sensitivity report of the problem is given as below where C = unit of Concert to be produced each day, S…arrow_forward
- Slim-Down Manufacturing makes a line of nutritionally complete, weight-reduction beverages. One of their products is a strawberry shake which is designed to be a complete meal. The strawberry shake consists of several ingredients. Some information about each of these ingredients is given below. Calories Total Vitamin Calories Content (per tbsp) (mg/tbsp) 50 20 100 0 120 80 Ingredient Strawberry flavoring Cream Vitamin supplement Artificial sweetener Thickening agent from fat (per tbsp) 1 75 0 0 30 0 50 0 2 Thickeners (mg/tbsp) 3 8 1 2 25 Cost (c/tbsp) 10 8 25 15 6 The nutritional requirements are as follows. The beverage must total between 380 and 420 calories (inclusive). No more than 20% of the total calories should come from fat. There must be at least 50 milligrams (mg) of vitamin content. For taste reasons, there must be at least two tablespoons (tbsp) of strawberry flavoring for each tbsp of artificial sweetener. Finally, to maintain proper thickness, there must be exactly 15 mg…arrow_forwardAn analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A B 1 Price per Unit 2 Cost per Unit 3 Profit per Unit PricePerUnit Cost_Per_Unit Profit per Unit 4 5 Fixed Costs Fixed_Costs 6 Variable Costs Variable Costs Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name PricePerUnit Cost Per_Unit Profit per Unit Fixed_Costs Variable Costsarrow_forwardSam is a new Nurse Practitioner (NP) in an independent physician-owned primary care office located in a small community. He loves working with the patients and gets along very well with his coworkers. Normally, Sam will see a patient on his own, or with a female nurse, if the patient is female. However, Sam recently noticed that his time with a patient was coded and billed to Medicare as one of the physician’s time. He recalled the legal course in nursing school about Medicare and knew that NP’s time is reimbursed at 80% of the actual charge or at 85% of the physician’s fee schedule amount, whichever is the lesser. He also remembered that the physician he was billed under was not in the office that day. Being concerned, he reviewed some additional records and discovered almost all of his time was coded and billed to Medicare as one of the physician’s time. When he questioned the billing clerk about the coding, her reply was “the Physician Assistant’s and NP’s time are always coded that…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,