35) What is the inventory at the end of the first quarter?A) 725B) 525C) 50D) 75 36) What is the binary constraint at the end of the third quarter?A) 75B) 200C) 450D) 0 37) What is the net production at the end of the first quarter?A) 75B) 200C) 450D) 600 Please answer all questions. Use the table below to answer the following question(s) using the standard Solver.Below is the spreadsheet for Memphis Designs fixed cost model:1Memphis Design Fixed Cost ModelDataQuarter 1$10.00$1.70Quarter 3$13.50$1.70Quarter 25ProductionCost$15.00Inventory$1.708.Demand200450759.Fixed CostS75.00$75.00$75.001011 Model1213Quarter 1Quarter 2Quarter 314 Production15 Inventory16 Binary1718 Binary constraints19 Net Production2021Cost22 Total2346 67

Name: 35) What is the inventory at the end of the first quarter?A) 725B) 525
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: 35) What is the inventory at the end of the first quarter?A) 725B) 525C) 50D) 75 36) What is the binary constraint at the end of the third quarter?A) 75B) 200C) 450D) 0 37) What is the net production at the end of the first quarter?A) 75B) 200C) 450D

Inventory: It refers to the goods used in the manufacturing of goods and services. Inventory is…

Business

Accounting

35) What is the inventory at the end of the first quarter? A) 725 B) 525 C) 50 D) 75 36) What is the binary constraint at the end of the third quarter? A) 75 B) 200 C) 450 D) 0 37) What is the net production at the end of the first quarter? A) 75 B) 200 C) 450 D) 600 Ple

35) What is the inventory at the end of the first quarter? A) 725 B) 525 C) 50 D) 75 36) What is the binary constraint at the end of the third quarter? A) 75 B) 200 C) 450 D) 0 37) What is the net production at the end of the first quarter? A) 75 B) 200 C) 450 D) 600 Ple

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 3E

See similar textbooks

Similar questions

Choose the correct letter of answer On a scattergrap, the diagonal line cuts across two sets of observations, namely: 600:200, and 900:500 which refer to costs and units, respectively. The fixed costs is plotted in the graph at P400. In this case, the variable cost per unit is equal to: a. P1.00b. P1.25c. P1.50d. P1.12
Sandra Saunders and her design team are analyzing theproduction costs for three alternative monitor designs.Given the cost information below, and assuming form andfunction are similar for each design, which monitor designwould you recommend? Monitor Fixed Cost Variable CostA $ 700,000 $250B $1,000,000 $125C $1,500,000 $100
The following problem is designed to be solved by spreadsheet. Suppose the supplier of keyboards is willing to offer the following incremental quantity discount schedule: Determine the cost to the firm for order quantities in increments of 20,000for Q = 200,000 to Q = 1,000,000, and compare that to the cost to the firm ofproducing internally for these same values of Q. What is the break-even orderquantity?
The graphs below represent cost behavior patterns that might occur in acompany's cost structure. The vertical axis represents total cost, and thehorizontal axis represents activity output. Required:For each of the following situations, choose the graph from the group a-1 that best illustrates the cost pattern involved. Also, for each situation,identify the driver that measures activity output. 1. The cost of power when a fixed fee of $500 per month is chargedplus an additional charge of $0.12 per kilowatt-hour used2. Commissions paid to sales representatives. Commissions arepaid at the rate of 5 percent of sales made up to total annual salesof $500,000, and 7 percent of sales above $500,000.3. A part purchased from an outside supplier costs $12 per part for the first 3,000 parts and $10 per part for all parts purchased inexcess of 3,000 units.4. The cost of surgical gloves, which are purchased in incrementsof 100 units (gloves come in boxes of 100 pairs).5. The cost of tuition at a…
Use the following data to solve problem #2: - Fixed costs $2,500 - Variable cost per unit $1.00 - Selling price per unit $6.00 - Run a simulation for production runs in increments of 100 (run 15) - At what production level in the company profitable - What is the amount of profit? - What is the maximum profit under these conditions - Show all work on a spreadsheet
Given the price and cost data shown in the accompanying table for each of the three firms, F, G, and H: (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Firm F G H Sale price per unit $18.00 $21.00 $30.00 Variable operating cost per unit 6.75 13.50 12.00 Fixed operating cost 45,000 30,000 90,000 a. What is the operating breakeven point in units for each firm? b. How would you rank these firms in terms of their risk?
A Corp has the following data: Prime cost of 800,000 Variable Mfg OH of 100,000 Fixed Mfg OH of 160,000 Variable OPEX of 80,000 Fixed OPEX of 40,000 What is the inventoriable cost under variable costing? What is the inventoriable cost under absorption costing?
On the Data Tables - Student tab in your Excel spreadsheet, update the given information section of the Income Statement for Hello Company with the data below: Income Statement Product A Product B Product C Max Capacity Units 42,000 7,000 3,000 52,000 Price per unit $ 11.00 $ 8.00 $ 60.00 Variable expense per unit $ 4.00 $ 2.00 $ 20.00 Total Fixed Costs $ 20,000 $ 40,000 $ 10,000 Required: 2. Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product based on the following scenarios. (Hint: Don't forget that the warehouse can only hold up to 52,000 units.) Scenario 1: Pete wants to find the mix of units that will result in the highest overall Operating Income, perform this analysis using a two variable data table. Product A can vary between 39,000 units and a maximum of 44,000 units. Product B can vary between 5,000 units…
46.) Given the following information, choose the cost and activity that would be used as the high data point in high-low cost estimation: Costs (P) Activity (hours)48 000 41 50049 000 42 00057 000 42 50056 000 43 00055 000 43 500Group of answer choices P57 000 and 42 500 hours P55 000 and 42 500 hours P57 000 and 43 500 hoursP55 000 and 43 500 hours P55 000 and 43 000 hours P56 000 and 43 500 hours
Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Refer to the information for Speedy Petes above. Speedy Petes controller wants to calculate the fixed and variable costs associated with its cutting-edge delivery service. Required: Using the high-low method, calculate the fixed cost of deliveries, calculate the variable rate per delivery, and construct the cost formula for total delivery cost. Use the following information for Brief Exercises 3-26 through 3-29: Speedy Petes is a small start-up company that delivers high-end coffee drinks to large metropolitan office buildings via a cutting-edge motorized coffee cart to compete with other premium coffee shops. Data for the past 8 months were collected as follows:
Open MFG2 and click the Chart sheet tab. The management of Twisp is convinced that the quality of its products is highly dependent on their relative labor costs. Experience has shown that direct labor should account for at least 45% of the total product cost. According to the pie chart that appears on the screen, Twisp did not achieve this goal in 2011. How much should Twisp have spent on direct labor to reach its 45% goal? To find out, try different values for direct labor (cell C8), clicking the Chart sheet tab after each attempt. When you find a direct labor level that increases the direct labor percentage to 45%, enter the answer in the space provided: In 2011, direct labor needed to be ________________. Open MFG3 and click the Chart sheet tab. Did Twisp achieve its 45% goal in 2012? If not, answer the following: In 2012, direct labor needed to be ________________. When the assignment is complete, close the files without saving them again. Worksheet. The MFG2 worksheet presents the companys manufacturing activities for 2011. The company also had the following selling and general activities in 2011: sales of 13,503,000, selling expenses of 2,400,000, and general expenses of 1,200,000. Modify the worksheet to include this information in the Data Section and change the Answer Section so that it is in the form of an income statement. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as MFGT. Hint: Expand the Data Section to include these additional input items alphabetically. Insert a row for sales under the heading in the Answer Section. Add the rest of the income statement information to the bottom of the schedule. You will need to enter formulas for gross profit, all the expenses, and net income. You will also need to change the statement name. Chart. Using the MFG2 file, prepare a single 3-D bar chart to show the dollar amount of materials, labor, and overhead incurred by Twisp in 2011 and 2012. Complete the Chart Data Table and use it as a basis for preparing the chart. Enter all appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as MFG2. Print the chart.