Number of ShoesPer Pair10 Overhead % of Labor1191213 Sales Volume - #pairs:14 Selling Price Per Pair:15tem16 Revenue1718 Cost of Goods Sold (per one shoe):19 Materials20 Direct Labor21 Overhead22 COGS Subtotal2324 Selling Expense (per one shoe)251 Instruction:21. Please complete the following budget plan using appropriate cell references format (the cells highlighted in grey)32. Please use fill handler to complete the table. E.g. in cell C16, build one formula and generate other formulas to D16 and E16 with fill handler.43. For "Cost of Goods Sold" section (before "COGS Subtotal"), build one formula in cell C19, and generate formulas until E21.54. For "COGS Subtotal", build one formula in C22, and generate the formulas to E22.65. Similar requirements for "Selling Expenses" and "Projected Earnings" section.76. Please be noted, for all items under "Cost of Goods Sold", and "Selling Expenses" the cost is per ONE shoe, not per pair.826 Projected Earnings2728B$Costs per Shoe+220%46.2010.282.068.00C$Low Priced1,200180Low PricedTotalD$Quarter BudgetMedium Priced780200 $EMedium PricedTotalHigh Priced360230FHigh Priced TotalGF

Cost of materials = $46.20 per shoeDirect labor costs = $10.28 per shoeOverhead costs = $2.06 per…

Answered: Number of Shoes Per Pair 10 Overhead %…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. UnitsProduced TotalLumberCost TotalUtilitiesCost Total MachineDepreciationCost 7,000 shelves $84,000 $9,550 $140,000 14,000 shelves 168,000 17,600 140,000 28,000 shelves 336,000 33,700 140,000 35,000 shelves 420,000 41,750 140,000 1. Determine whether the costs in the table are variable, fixed, mixed, or none of these. Lumber Utilities Depreciation 2. For each cost, determine the fixed portion of the cost, and the per-unit variable cost. If there is no amount or an amount is zero, enter "0". Recall that, for N = Number of Units Produced, Total Costs = (Variable Cost Per Unit x N) + Fixed Cost. Complete the following table with your answers. Round variable portion…
Answer question 3-4 using the information below: Fantasy Book and Music Store has two support departments and two production departments. Costs of each department are presented below. Data on budgeted warehouse-hours and number of computer log-on hours for cost allocation of support departments are as follows: Support Departments Production Departments Warehouse Data Center Music Books Budgeted costs Budgeted warehouse-hours Number of computer hours $495,000 1,750 $412,500 3,500 2,800 $1,155,000 $495,000 N/A 5,250 3,500 700 N/A 3. Using the direct method, how much are the total costs of the Books Department? A. $495,000 B. $275,000 C. $693,000 D. $1,463,000 4. Using the step-down method, what amount of Data Center Department cost will be allocated to Music Department if the service department with the highest percentage of interdepartmental support service is allocated first? A. $387,229 B. $220,001 C. $307,267 D. $381,150
Help Save & Exit AA company provided the following information from its flexible budget performance report: Actual Results 52 Flexible Budget Master Budget Trips (q) 2. Expenses: Maintenance expense ($4,000 + $88.00g) $8,440 $8,400 What is the spending variance for maintenance expense? Multiple Choice $136 F $136 U $176 U Nex 11 of 23 < Prev
Current Attempt in Progress Concord rents DVDS that are mailed out to customers upon demand. Concord has identified three activities involved in getting the videos to its customers. Information on those activities for the month of July follows: Estimated Overhead Cost Expected Use of Cost Drivers Cost Pools Cost Drivers Order taking costs $20230 Number of orders 202300 orders Technology support Number of 234700 minutes 11300 minutes Picking and shipping Number of DVDs 36920 330800 DVDS costs During July, the Tucker family placed 18 orders consisting of 23 DVDS. Tucker required 6 minutes of tech support. Customers pay $12 per month to rent unlimited DVDS. Using ABC, how much overhead is applied to the Tucker family account for order taking costs? O $4.10 O $1.80 O $2.30 O $6.40 Attempts: 0 of 1 used Save for Later Submit Answer 9:24 P 10/13/2 hp
A manufacturer uses activity-based costing to assign overhead cost to products. Budgeted cost information for its activities follows. Budgeted Cost $ 210,600 Activity Cost Driver Purchase orders Square feet Budgeted Activity Usage 5,400 purchase orders 5,900 square feet 50 Setups Factory services 104,250 Setup 67,750 Setups Compute an activity rate for each activity. (Round your answers to 2 decimal places.) Activity Purchasing Activity Purchasing Factory services Setup Budgeted Cost 210,600 104,250 67,750 $ $ $ Budgeted Activity Usage Activity Rate
Data table Units of D4H produced and sold 1. 2. Selling price 3. Direct materials (kilograms) 4. Direct material cost per kilogram 5. Manufacturing capacity (units of D4H) 6. Total conversion costs 7. 8. Selling and customer-service capacity 9. Total selling and customer-service costs 10. Selling and customer-service capacity cost per customer 11. Design staff 12. Total design costs 13. Design cost per employee Conversion cost per unit of capacity Alt+Q Print Done $ $ 210 41,000 $ 310,000 7.25 $ 250 2,125,000 $ 8,500 $ $ $ 2,150,000 8,600 95 customers 90 customers 900,000 10,000 12 1,045,000 $ 11,000 $ 12 1,212,000 $ 101,000 $ $ $ ZUZT $ $ ZUZZ 235 43,000 325,000 7.75 250 1,218,000 101,500 (similar to) Data table HW Score: 3.03%, 0.12 of 4 points Daint 0 10 of 1 Revenue effect of growth Cost effect of growth The company has chosen a product differentiation strategy. The growth, price- recovery, and productivity components of the change in operating income from 2021 to 2022 are as…
Assume a company's activity-based costing system includes three activities with the following activity rates: Activity Cost Pool Activity Rate Travel $ 2 per mile driven Deliveries $ 50 per delivery Customer service $ 22 per phone call Two of the company's many customers include Customer A and Customer B. These two customers consumed the company's activities as follows: Total Expected Activity Customer A Customer B Travel (number of miles driven) 300 250 Deliveries (number of deliveries) 15 5 Customer service (number of phone calls) 20 12 If the company earned $1,130 in revenue serving Customer B, then what is the customer margin for this customer? Multiple Choice $96 $156 $116 $136
ezto.mheducation.com Homework: Cost Management and Allocation Assignment Question 7- Homework: Cost Management and Allocation Assignment- Connect Homework: Cost Management and Allocation Assignm... i Saved Help Save & Exit Submit Check my work State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows. 4. points Administration Communications Facilities Deposits $8,320,000 $4,600,000 447, 000 Loans Direct costs $200,000 24,000 $290,000 31,000 $253,000 20,500 Employee hours Number of employees Square footage occupied Skipped 360,000 8. 14 6. 230 130 4,600 13,800 5,100 244, 100 203,300 The costs of the service departments are allocated on the following bases: Administration, employee-hours; Communications, number of employees; and Facilities, square…
Question 2 Use the following standard cost card for 1 gallon of ice cream to answer the questions. STANDARD COST CARD Product: Gallon of Ice Cream Standard Cost Manufacturing Cost Information Standard Cost Quantity per Unit Summary Direct Materials Cream 5 quarts $1.15 per quart $0.08 per ounce $36.00 per hour $5.75 Sugar 16 ounces $1.28 Direct Labor 3 minutes $1.80 Total Direct Costs $8.83 Actual direct costs incurred to make 50 gallons of ice cream: 275 quarts of cream at $1.05 per quart 832 ounces of sugar at $0.075 per ounce 165 minutes of labor at $37 per hour All material used was bought during the current period. C. Compute the material and labor variances. D. Comment on the results and possible causes of the variances.
ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A% merica AS... rk i Required information Use the following information for the Problems below. (Algo) [The following information applies to the questions displayed below.] Trini Company set the following standard costs per unit for its single product Direct materials (30 pounds @ $5.00 per pound) $ 150.00 98.00 Direct labor (7 hours @ $14 per hour) Variable overhead (7 hours @ $7 per hour) Fixed overhead (7 hours @ $9 per hour) Standard cost per unit Production (in units) Standard direct labor hours (7 DLH per unit) Budgeted overhead (flexible budget) Fixed overhead Variable overhead Overhead is applied using direct labor hours. The standard overhead rate is based on a predicted activity level of 80% of the company's capacity of 51,000 units per quarter. The following additional information is available. 49.00 63.00 $360.00 70% 35,700 249,900 Direct materials (1,377,000 pounds @ $5.00 per pound)…
Cornerstone Exercise 7-31 Calculating ABC Unit Costs oqrmo gninobro9n ageaea Perry National Bank has collected the following information for four activities and two types of credit cards:en wallokae she aitkop 7pilnquao.bobbonsisbbdo bns noiteanol 2000 ei i bas 1251 orlu boliel oved aomoqmos srls to diod TO Activity Driver Classic Gold Activity Rate Processing transactions Preparing statements re e Number of statements Answering questions Exer Providing ATMS Transactions processed 8,000 e 8,000 viirio/4,800 16,000 32,000 4,800 $0.15 0.90 Number of calls 3.00 24,000 9,600 ATM transactions 1.20 There are 5,000 holders of Classic cards and 20,000 holders of the Gold cards. activities: Required: ese twoho tion molding Calculate the unit cost (rounded to the nearest cent) for Classic and Gold credit cards. The Cornerstone Exercise 7-32 Assigning Costs to Activities Baker Company produces small engines for lawnmower producers. The accounts payable depart- ment at Baker has six clerks who…
Conlon Enterprises reports the following information about resources. Cost Driver Rate Cost Driver Volume Resources used Setups $ 370 per run 425 runs Clerical 50 per page 2,500 pages typed Resources supplied Setups $ 160,450 Clerical 133,400 Sales revenue totaled $315,000. Required: a. Prepare a traditional income statement. b. Prepare an activity-based income statement.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS