The Excel worksheet form that appears below is to be used to recreate the example in the text related to Santa Maria Wool Cooperative. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
Required:
Check vow worksheet by changing the cost of further processing undyed coarse wool in cell B12 to $30,000. The overall profit from processing all intermediate products into final products should now be $150,000 and the financial advantage of further processing coarse wool should now be $10,000. If you do not get these answers, find the errors in your worksheet and correct them.
How should operations change in response to this change in cost?
Want to see the full answer?
Check out a sample textbook solutionChapter 11 Solutions
Introduction To Managerial Accounting
- Piper Rose Boutique has been approached by the community college to make special polo shirts for the faculty and staff. The college is willing to buy 4,000 polos with its own design for $6.00 each. The company normally sells its shirts for $12.00 each. The company has enough excess capacity to make this order. A breakdown of the costs is as follows: Direct materials $2.00 Direct labor 0.50 Variable factory overhead 1.50 Fixed factory overhead 2.50 Total cost per unit $6.50 Should Piper Rose Boutique accept the special order made by the college? Proposal to Sell Polo Shirts to College Differential revenue from accepting offer ? Differential variable costs of additional units ? Differential income (loss) from accepting the offer ? The order should be .arrow_forwardCan some one double check this for me? You plan to open a small business for manufacturing pet collars, leashes, and harnesses. You have found a workshop space you can use for sewing your products. After some research and planning, you have estimates for the various operating costs for your business. The total square footage for the sewing rooms is 1,500 square feet broken into three areas (500 square feet each). You have taken out a loan for start-up costs, and the monthly payment is $550; it goes into effect immediately and should be accounted for in your costs. You will also collect a modest salary for the first year of $500 per month; remember to divide evenly among the services. Salary and Hiring Data · One collar maker, who will be paid $16.00 per hour and work 40 hours per week · One leash maker, who will be paid $16.00 per hour and work 40 hours per week · One harness maker, who will be paid $17.00 per hour and work 40 hours per week · One receptionist, who will be paid…arrow_forwardNotson, Inc. produces several models of clocks. An outside supplier has offered to produce the commercial clocks for Notson for $420each. Notson needs 1,200 clocks annually. Notson has provided the following unit costs for its commercial clocks: Direct materials $100 Direct labor 140 Variable overhead 80 Fixed overhead (40% avoidable) 150 Prepare an incremental analysis which shows the effect of the make-or-buy decision. Please solve this if any more information is needed let me know.arrow_forward
- Colin OShea has a carpentry shop that employs 4 carpenters. Colin received an order for 1,000 coffee tables. The coffee tables have a round table top and four decorative legs. An offer for $500 per table was received. Colin found an unfinished round table top that he could buy for $50 each. A. Using this quantitative cost data to make the table top, should Colin buy the table top or make it? B. What qualitative factors would be included in your decision. B. Can the vendor make it to the same quality standards? Can it be completed on time? Is there idle capacity in the factory that could be used?arrow_forwardAssume you are the leather department manager at the Famous Football Factory. The leather department is a cost center and you are reviewing the scrap costs for the previous year, shown here: A. Using Microsoft Excel or another spreadsheet application, create a line chart with markers showing the leather scrap expense. Describe your observations. B. Knowing that leather is susceptible to indoor temperature, you decide to talk with the maintenance manager and obtain the following information: Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the indoor temperature, spare parts inventory, and breakdowns. Describe your observations and actions you might consider.arrow_forwardErba Inc. has the following departmental layout for producing an herbal supplement: After a detailed study, the head of the plants industrial engineering department recommended that the following cellular manufacturing layout replace the current departmental structure: Required: 1. Calculate the time required to produce a batch of 12 bottles using a batch processing departmental structure. 2. Calculate the time to process 12 units using cellular manufacturing. 3. How much manufacturing time will the cellular manufacturing structure save for a batch of 12 units? 4. How many units can the cell produce per hour, assuming the cell is producing on a continuous basis? 5. What must happen so that the cell can produce 12 units per hour, assuming the cell produces on a continuous basis?arrow_forward
- Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producing a kitchen chair at each of the two plants is given here. The cost of producing Q1 chairs at Aynor is: 75Q1+5Q12+100 and the cost of producing Q2 kitchen chairs at Spartanburg is: 25Q2+2.5Q22+150. Andalus needs to manufacture a total of 40 kitchen chairs to meet an order just received. How many chairs should be made at Aynor, and how many should be made at Spartanburg in order to minimize total production cost?arrow_forwardQuality Clothing, Inc., produces skorts and jumper uniforms for schoolchildren. In the process of cutting out the cloth pieces for each product, a certain amount of scrap cloth is produced. Quality has been selling this cloth scrap to Jorges Scrap Warehouse for $3.25 per pound. Last year, the company sold 40,000 lb. of scrap, which would be enough to make 10,000 teddy bears that the management of Quality is now interested in producing. Their processes would need some reprogramming, particularly in the cutting and stitching processes, but it would require no additional worker training. However, new packaging would be needed. The total variable cost to produce the teddy bears $3.85. Fixed costs would increase by $95,000 per year for the lease of the packaging equipment and Quality estimates it could produce and sell 10,000 teddy bears per year. Finished teddy bears could be sold for $18.00 each. Should Quality continue to sell the scrap cloth or should Quality process the scrap into teddy bears to sell?arrow_forwardBrindis Babysitting Center currently rents a 1200 sq foot facility for her 20-child facility. Her business has gotten five stars on Yelp, which has prompted more applications. She has to make a decision between expanding her operations to an 1,800 sq foot facility or staying in the current facility. Shown is the cost data of the options: What is the differential cost of the two alternatives: A) move to a larger facility or B) stay in current facility?arrow_forward
- Keith Golding has decided to purchase a personal computer. He has narrowed his choices to two: Brand A and Brand B. Both brands have the same processing speed, hard disk capacity, RAM, graphics card memory, and basic software support package. Both come from companies with good reputations. The selling price for each is identical. After some review, Keith discovers that the cost of operating and maintaining Brand A over a three-year period is estimated to be 200. For Brand B, the operating and maintenance cost is 600. The sales agent for Brand A emphasized the lower operating and maintenance cost. She claimed that it was lower than any other PC brand. The sales agent for Brand B, however, emphasized the service reputation of the product. She provided Keith with a copy of an article appearing in a PC magazine that rated service performance of various PC brands. Brand B was rated number one. Based on all the information, Keith decided to buy Brand B. Required: 1. What is the total product purchased by Keith? 2. Is the Brand A company pursuing a cost leadership or differentiation strategy? The Brand B company? Explain. 3. When asked why he purchased Brand B, Keith replied, I think Brand B offered more value than Brand A. What are the possible sources of this greater value? If Keiths reaction represents the majority opinion, what suggestions could you offer to help improve the strategic position of Brand A?arrow_forwardPaper Roses Boutique has been approached by the community college to make special polo shirts for the faculty and staff. The college is willing to buy 4,000 polos with its own design for P6.00 each. The company normally sells its shirts for P12.00 each. The company has enough excess capacity to make this order. A breakdown of the costs is as follows: Direct materials P2.00 Direct labor 0.50 Variable factory overhead 1.50 Fixed factory overhead _2.50 Total cost per unit P6.50 Should Paper Roses Boutique accept the special order made by the college? Show computations, but a formal differential analysis report is not required.arrow_forwardThe design engineering team has proposed a modification that would lower the weaving department’s rate of defective products to 3%. The modification would cost the company $700,000 per month. Should Dover implement the change? Show your calculations.arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning