Calculation with Excel Fill in the table and made conclusionsCalculation per 1 monthCosts500700Expected sales volume, itemsEstimated price per unitTotal direct (variable) costs1,4951,400"Marginal profit" per unitThe total "marginal profit"Fixed costs at 100% capacity utilizationRealized profitFor production process you need operators and raw materials (wood)Salaries per monthOperator30,000 RUBGeneral director220,000 RUBAccountant130,000 RUBIngenear90,000RUBMarketing specialist110,000 RUBLeasing1,272RUB/m2/yearProduction area120m2Administration area47m3Equipment100,000RUBUsage term7 years1 m2 of wood costs 1030 RUB. Every additional m2 has discout of 2% in compare with previous>=100 m21,030-200 m21,009>=300 m2989>=400 m2969>=500 m2950For production of 1 finished item requiresof labor timeof wood39 min0.44 m2IIIVariantsIII9001,245IV1,0001,159

The working table is given as, Note 1: Total Direct Variable Cost I II III IV Estimated sales…

Answered: Calculat ed sales vc ted price p

Business

Accounting

Calculat ed sales vc ted price p

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter7: Variable Costing For Management analysis

Section: Chapter Questions

Problem 4BE

See similar textbooks

Similar questions

Quality Cost Report Loring Company had total sales of 2,400,000 for fiscal 20X1. The costs of quality-related activities are given below. Required: 1. Prepare a quality cost report, classifying costs by category and expressing each category as a percentage of sales. What message does the cost report provide? 2. Prepare a bar graph and pie chart that illustrate each categorys contribution to total quality costs. Comment on the significance of the distribution.
Identify cost graphs The following cost graphs illustrate various types of cost behavior: For each of the following costs, identify the cost graph that best illustrates its cost behavior as the number of units produced increases: A. Total direct materials cost B. Electricity costs of 1,000 per month plus 0.10 per kilowatt-hour C. Per-unit cost of straight-line depreciation on factory equipment D. Salary of quality control supervisor, 20,000 per month E. Per-unit direct labor cost
The following information pertains to Vladamir, Inc., for last year: There are no work-in-process inventories. Normal activity is 100,000 units. Expected and actual overhead costs are the same. Costs have not changed from one year to the next. Required: 1. How many units are in ending inventory? 2. Without preparing an income statement, indicate what the difference will be between variable-costing income and absorption-costing income. 3. Assume the selling price per unit is 29. Prepare an income statement using (a) variable costing and (b) absorption costing.
Contribution margin, break-even sales, cost-volume-profit chart, margin of safety, and operating leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows: It is expected that 12,000 units will be sold at a price of 240 a unit. Maximum sales within the relevant range are 18,000 units. Instructions 1. Prepare an estimated income statement for 20Y7. 2. What is the expected contribution margin ratio? 3. Determine the break-even sales in units and dollars. 4. Construct a cost-volume-profit chart indicating the break-even sales. 5. What is the expected margin of safety in dollars and as a percentage of sales? (Round to one decimal place.) 6. Determine the operating leverage.
Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:
Lotts Company produces and sells one product. The selling price is 10, and the unit variable cost is 6. Total fixed cost is 10,000. Required: 1. Prepare a CVP graph with Units Sold as the horizontal axis and Dollars as the vertical axis. Label the break-even point on the horizontal axis. 2. Prepare CVP graphs for each of the following independent scenarios: (a) Fixed cost increases by 5,000, (b) Unit variable cost increases to 7, (c) Unit selling price increases to 12, and (d) Fixed cost increases by 5,000 and unit variable cost is 7.
Suppose that a company is spending 60,000 per year for inspecting, 30,000 for purchasing, and 40,000 for reworking products. A good estimate of nonvalue-added costs would be a. 70,000. b. 130,000. c. 40,000. d. 90,000. e. 100,000.
Evans Company had total sales of 3,000,000 for fiscal 20x5. The costs of quality-related activities are given below. Required: 1. Prepare a quality cost report, classifying costs by category and expressing each category as a percentage of sales. What message does the cost report provide? 2. Prepare a bar graph and pie chart that illustrate each categorys contribution to total quality costs. Comment on the significance of the distribution. 3. What if, five years from now, quality costs are 7.5 percent of sales, with control costs being 65 percent of the total quality costs? What would your conclusion be?
Bethany Company has just completed the first month of producing a new product but has not yet shipped any of this product. The product incurred variable manufacturing costs of 5,000,000, fixed manufacturing costs of 2,000,000, variable marketing costs of 1,000,000, and fixed marketing costs of 3,000,000. Under the variable costing concept, the inventory value of the new product would be: a. 5,000,000. b. 6,000,000. c. 8,000,000. d. 11,000,000.
Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
Cost Classification Loring Company incurred the following costs last year: Required: 1. Classify each of the costs using the following table format. Be sure to total the amounts in each column. Example: Direct materials, 216,000. 2. What was the total product cost for last year? 3. What was the total period cost for last year? 4. If 30,000 units were produced last year, what was the unit product cost?
Income Statements under Absorption and Variable Costing In the coming year, Kalling Company expects to sell 28,700 units at 32 each. Kallings controller provided the following information for the coming year: Required: 1. Calculate the cost of one unit of product under absorption costing. 2. Calculate the cost of one unit of product under variable costing. 3. Calculate operating income under absorption costing for next year. 4. Calculate operating income under variable costing for next year.