Can I pay with paypal
Chapter 1 Applying Excel Chapter 1: Applying Excel Data Sales$12,000 Variable costs: Cost of goods sold$6,000 Variable selling$600 Variable administrative$400 Fixed costs: Fixed selling$2,500 Fixed administrative$1,500 Enter a formula into each of the cells marked with a ? below Exhibit 1-7 Traditional Format Income Statement Sales? Cost of goods sold? Gross margin? Selling and administrative expenses: Selling? Administrative?? Net operating income? Contribution Format Income Statement Sales? Variable expenses: Cost of goods sold? Variable selling? Variable administration?? Contribution margin? Fixed expenses: Fixed selling? Fixed administrative?? Net operating income? The Foundational 15 Chapter 1. The Foundational 15 Martinez company's relevant range of p;roduction is 7,500 units to 12,500 units. When it produces and sells 10,000 units, its average costs per unit are as follows: Average Cost per Unit Direct materials$6.00 Direct labor $3.50 Variable manufacturing overhead$1.50 Fixed manufacturing overhead$4.00 Fixed selling expense$3.00 Fixed administrative expense$2.00 Sales commissions$1.00 Variable administrative expense$0.50 Using an Excel formula, answer the following: 1. For financial accounting purposes, what is the total amount of product costs incurred to make 10,000 units? 2. For financial accounting purposes, what is the total amount of period costs incurred to sell 10,000 units? 3. If 8,000 units are produced and sold, what is the variable cost per units produced and sold? 4. If 12,500 units are produced and sold, what is the variable cost per unit produced and sold? 5. If 8,000 units are produced and sold, what is the total amount of variable costs related to the units produced and sold? 6. If 12,500 units are produced and sold, what is the total amount of variable costs related to the units produced and sold? 7. If 8,000 units are produced, what is the average fixed manufacturing cost per units produced? 8. If 12,500 units are produced, what is the average fixed manufacturing cost per unit produced? 9. If 8,000 are produced, what is the total amount of fixed manufacturing cost incurred to support this level of production? 10. If 12,500 units are produced, what is the total amount of fixed manufacturing cost incurred to support this level of production? 11. If 8,000 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production? What is this total amount expressed on a per unit basis? 12. If 12.500 units are produced, what is the total amont of manufacturing overhead cost incurred to support this level of production? What is this total amount expressed on a per unit basis? 13. If the selling price is $22 per unit, what is the contribution margin per unit? 14. If 11,000 units are produced, what are the total amounts of direct and indirect manufacturing costs incurred to support this level of production? 15. What incremental manufacturing cost will Martinez incur if it increases production from 10,000 to 10,001 units? Applying Excel Chapter 2: Applying Excel Company X has 2 departments, Milling and Assembly, in its operation to produce its product. Using Excel functions and formulas, complete the required answers wherever there is a "?". This applies the concepts of calculating predetermined overhead and then using the rates to apply the overhead based on the cost driver, calculate the product total cost, and then a selling price based on cost plus a markup. Data Markup on job cost75% Department MillingAssembly Machine-hours60,0003,000 Direct labor-hours8,00080,000 Total fixed manufacturing overhead cost$390,000$500,000 Variable manufacturing overhead per machine-hour$2.00 Variable manufacturing overhead per direct labor-hour$3.75 Cost summary for Job 407Department MillingAssembly Machine-hours904 Direct labor-hours520 Direct materials$800$370 Direct labor cost$70$280 Enter a formula into each of the cells marked with a ? below Step 1: Calculate the estimated total manufacturing overhead cost for each department MillingAssembly Total fixed manufacturing overhead cost?? Variable manufacturing overhead per machine-hour or direct labor-hour?? Total machine-hours or direct labor-hours?? Total variable manufacturing overhead?? Total manufacturing overhead?? Step 2: Calculate the predetermined overhead rate in each department MillingAssembly Total manufacturing overhead?? Total machine-hours or direct labor-hours?? Predetermined overhead rate per machine-hour or direct labor-hour?? Step 3: Calculate the amount of overhead applied from both departments to Job 407 MillingAssembly Predetermined overhead rate per machine-hour or direct labor-hour?? Machine-hours or direct labor-hours for the job?? Manufacturing overhead applied?? Step 4: Calculate the total job cost for Job 407 MillingAssemblyTotal Direct materials??? Direct labor cost??? Manufacturing overhead applied??? Total cost of Job 407? Step 5: Calculate the selling price for Job 407 Total cost of Job 407? Markup? Selling price of Job 407?