Module 2 Excel Exercise (1)

p.mheducation.com/ext/map/index.html?_con=con&external_browser%3D0&launchUrl=https%253A%252F%252Flms.mhe D and P Indeed 6 Monster Jobs w Degree Programs O L02 A Hearn: Student Da.. 6 Consumer Center ework: Assignment 1 i Saved Perez Company reported the following operating results for two consecutive years: Required Compute each income statement component for each of the two years as a percentage of sales due to rounding. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be e PEREZ COMPANY Vertical Analysis of Income Statements Percentage of Sales Percentage of Sales Year 4 Year 3 Sales 1,077,500 00S'000'L Cost of goods sold 550,275 000 Z09 Gross margin on sales 450,225 475,500 Operating expenses 130,500 149,800 319.725 325,700 Income before taxes 79.700 81,800 Income taxes 240.025 243.900 % Net income

eBook   Show Me How   Office 365 Question Content Area Profit center responsibility reporting Championship Sports Inc. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Line Item Description Amount Sales—Winter Sports Division $9,600,000 Sales—Summer Sports Division 15,000,000 Cost of Goods Sold—Winter Sports Division 5,500,000 Cost of Goods Sold—Summer Sports Division 9,500,000 Sales Expense—Winter Sports Division 780,000 Sales Expense—Summer Sports Division 1,000,000 Administrative Expense—Winter Sports Division 700,000 Administrative Expense—Summer Sports Division 1,440,000 Advertising Expense 1,099,000 Transportation Expense 150,000 Accounts Receivable Collection Expense 67,000 Warehouse Expense 966,000…

Question 14 of 15. Net Sales = $145,347 Employee Meals $1,923 Discounts $221 Coupons/Promotions-$988 What is the Gross Sales? O$138.588 O$140,156 O$145.224 O$148 479 Mark for follow up

Q.

Chapter 9: Applying Excel Data Revenue Cost of ingredients Wages and salaries Utilities Rent $16.50 q $6.25 q $10,400 $800 + $0.20 q $2,200 $600 + $0.80 q Miscellaneous Actual results: Revenue $27,920 Cost of ingredients $11,110 Wages and salaries $10,130 Utilities $1,080 Rent $2,200 Miscellaneous $2,240 Planning budget activity 1,800 meals served Actual activity 1,700 meals served Enter a formula into each of the cells marked with a ? below Review Problem: Variance Analysis Using a Flexible Budget Construct a flexible budget performance report Revenue and Actual Spending Flexible Activity Planning Results Variances Budget Variances Budget Meals served ? ? ? Revenue ? ? ? ? ? Expenses: Cost of ingredients ? ? ? ? ? Wages and salaries ? ? ? ? ? ? ? ? ? ? Utilities ? ? ? ? ? Rent Miscellaneous ? ? ? ? ? ? ? ? ? ? Total expenses Net operating income ? ? ? ? ?

Student workpoint 3.7 Be knowledgeable The following information was provided by David, a candle producer, based on his monthly production and sales. Table 3.3.1 Quantity Price per Revenue Fixed Variable Total Profit/ of candle candle from costs costs costs (Loss) (USS) box sold [Total] [Total) (US$S) (USS) boxes box candle (USS) sold (USS) (USS) $10 2,000 2,000 (2,000) 200 $10 2,000 2,000 1,200 3,200 400 $10 4,000 2,000 2,400 4,400 600 $10 6,000 2,000 3,600 5,600 008 1,000 $10 8,000 2,000 4,800 6,800 1200 $10 10 000 2,000 6,000 8,000 1,200 s10 12 000 2,000 7,200 9,200 Referrring to Table 3.3.1, answer the questions below. 1. Complete the profit/(loss) column. 2. Calculate the variable cost per candle box. 3. Draw a break-even graph using the information in the table and show the break-even quantity on your graph. 4. Show on the graph the margin of safety at 1,200 candle boxes sold.

Homework Question 4

Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) v A A 11 Wrap Text v В I U Merge & Centem fx B E F CLR Question Lesson Objective # Ma Q4: Solve the following 2 problems related to employee compensation CLR 1-Obj. 4 L2 a. Jon is employed at annual salary of $41995. His regular work week is 38 hours and he is paid semi-monthly i. What is Jon's Gross pay per period? ii. What is hourly rate of pay? iii. What is his gross pay for a period in which work 12 hours of overtime and he is paid overtime at time and a half of What is a salesperson's commission on net sales of $17800 if the commission is paid on a sliding scale of 7%% on the first $7000, 8%% on the next $8000 and 12.5% on sales over $15000? b. CLR 1- Obj. 5 L2 Mark Q5: Solve the following 3 problems related to GST, HST, PST, 公 四

BB Home Insert A Page Layout Formulas Data Review View B C D E F SUPPORT 1 DEPARTMENTS OPERATING DEPARTMENTS Human Information Corporate Consumer 234 Resources Systems Sales Sales 3 Budgeted costs incurred before any interdepartment cost allocations $72,700 $234,400 $998,270 $489,860 Support work supplied by human 5 resources department 6 Budgeted number of employees Support work supplied by information 7 systems department 80 - 21 42 28 Budgeted processing time (in minutes) 320 - 1,920 1,600

Question 18 View Policies Current Attempt in Progress E-Flix rents DVDS that are mailed out to customers upon demand. E-Flix has identified three activities involved in getting the videos to its customers. Information on those activities for the month of July follows: Estimated Expected Use of Cost Drivers Cost Pools Cost Drivers Overhead Cost Order taking costs Number of orders $20,592 187,200 orders Technology support Number of minutes $11,700 234,000 minutes Picking and shipping Number of DVDS $39,624 330,200 DVDS costs During July, the Tucker family placed 17 orders consisting of 21 DVDS. Tucker required 7 minutes of tech support. Customers pay $9.00 per month to rent unlimited DVDS. Using ABC, how much overhead is applied to the Tucker family account for technology support? O Some other answer O $1.87 O $0.05 o$0.35 2:28 P ) 10/13/23

Chapter 5 Activity-Based Costing and Management Problem 5-57 Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by custom- er type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer catego- ries and their associated annual costs are as follows: Opening and closing accounts Issuing monthly statements Processing transactions Customer inquiries $ 300,000 450,000 3,075,000 0000 Providing automatic teller machine (ATM) services 600,000 Total cost 1,680,000 $6,105,000 Additional data concerning the usage of the activities by the various customers are also provided: Account Balance Low Medium High Number of accounts opened/closed 22,500 4,500 3,000 Number of statements issued 675,000 150,000 75,000 Processing transactions 27,000,000 3,000,000 750,000 Number of telephone minutes 1,500,000 900,000 600,000 Number…

eBook Print Item Question Content Area Relevant data from the Poster Company’s operating budgets are:   Quarter 1 Quarter 2 Sales $208,470 $211,539 Direct material purchases 115,290 120,831 Direct labor 75,200 73,300 Manufacturing overhead 25,400 25,200 Selling and administrative expenses 33,400 33,400 Depreciation included in selling and administrative 1,500 1,100 Collections from customers 215,392 240,154 Cash payments for purchases 114,300 119,252 Additional data:Capital assets were sold in January for $11,000 and $4,500 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $58,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quarters   Quarter 1 Quarter 2   $- Select - $- Select - Add: Cash Receipts       - Select - -…

EXERCISE 12-4 The Income Statement columns of the August 31 (year-end) work sheet for Ralley Company are shown here, From the information given, prepare income statement for the company. To save time and space, the expenses have been grouped together into two categories. LO Pra Show m HOV 4 5 ACCOUNT NAME INCOME STATEMENT DEBIT 7 CREDIT 23 Income Summary Sales 32,000.00 31,000.00 324,000.00 24 25 Sales Returns and Allowances 13,310.00 7,700.00 126,360.00 26 Sales Discounts Purchases Purchases Returns and Allowances Purchases Discounts 27 1,200.00 1,300.00 28 29 30 7,500.00 61,560.00 Freight In 31 50,884.00 299,314.00 58.188.00 357,500.00 Selling Expenses 357,500.00 32 General Expenses 33 357,500.00 34 Net Income 35 36 Sheet3 Sheet2 Sheett

Required information Problem 9-2A (Algo) Allocation of indirect expenses to departments LO P2 [The following information applies to the questions displayed below.] National Retail has two departments, Housewares and Sporting. Indirect expenses for the period follow. Rent Advertising Insurance Total $ 45,000 25,000 10,000 $ 80,000 The company occupies 4,000 square feet of a rented building. In prior periods, the company divided the $80,000 of indirect expenses by 4,000 square feet to find an average cost of $20 per square foot, and then allocated indirect expenses to each department based on the square feet it occupied. The company now wants to allocate indirect expenses using the allocation bases shown below. Department Housewares Sporting Total Square Feet 2,040 1,960 4,000 Sales $ 220,000 280,000 $ 500,000 Value of Insured Assets $ 44,000 56,000 $ 100,000

How do I figure the gross up amount and regular gross pay per period?

Need help with this question

e Preview 4) F3 $ R 01- Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Category Price Cost of goods sold Gross profit F4 Customer service Project bidding Engineering support Total costs In addition, the company incurs selling and administrative expenses of $226,250. The company wishes to assign these costs to its three major customers, Gough Industries, Breen Inc., and The Martin Group. These expenses are related to three major nonmanufacturing activities: customer service, project bidding, and engineering support. The engineering support is in the form of engineering changes that are placed by the customer to change the design of a product. The budgeted activity costs and activity bases associated with these activities are: S⁰5 Activity Number of service requests Number of bids Number of customer design changes Unit volume % Activity 3:0 F5 T Activity-base usage and unit volume information for the…

Customers balance December 31, 2023 om customers e balance, March 31, 2024: cted in 2nd Ot 2024 Data table Total sales Budgeted purchases of direct matenal Budgeted direct labor cost Budgeted manufacturing overhead costs Variable manufacturing overhead Depreciation Insurance and property taxes Budgeted selling and administrative expenses Salaries expense Rent expense Insurance experese Depreciation experie Supples expense Print Done 208.000 40,900 37,500 1,100 1.200 6,700 4,000 1,000 1,400 6.240

4 Chapter : Manufacturing Accounting

Island Novelties, Incorporated, of Palau makes two products-Hawailan Fantasy and Tahitian Joy. Each product's selling price, variable expense per unit and annual sales volume are as follows: Selling price per unit Variable expense per unit Number of units sold annually Fixed expenses total $325,000 per year Hawaiian Fantasy $ 20 $13 15,000 Check my wor Tahitian Joy $ 125 $ 50 5,100 Required: 1. Assuming the sales mix given above, do the following a. Prepare a contribution format income statement showing both dollar and percent columns for each product and for the comparty as a whole. b. Compute the company's break-even point in dollar sales. Also, compute its margin of safety in dollars and its margin of safety percentage 2. The company has developed a new product called Samoan Delight that sells for $45 each and that has variable expenses of $27 per unit. If the company can sell 12,500 units of Samoan Delight without incurring any additional fixed expenses: a. Prepare a revised…

Problem: Module 6 Textbook Problem 7 Learning Objective: 6-4 Make appropriate segment elimination decisions Perez Company operates three segments. Income statements for the segments imply that profitability could be improved if Segment A were eliminated. Segment Sales Cost of goods sold Sales commissions Contribution margin General fixed operating expenses (allocation of president's salary) Advertising expense (specific to individual divisions) Net income (loss) PEREZ COMPANY Income Statements for Year 2 Complete this question by entering your answers in the tabs below. Required A Required B PEREZ COMPANY Comparative Income Statements for the Year 2 Decision Sales Cost of goods sold Sales commissions Contribution margin General fixed operating expenses Advertising expense Net Income Keep Seg. A Eliminate Seg. A A $ 166,000 (128,000) (21,000) Required a. Prepare a schedule of relevant sales and costs for Segment A. b. Prepare comparative income statements for the company as a whole…

EXERCISE 1-15 Traditional and Contribution Format Income Statements L01-6 The Alpine House, Inc., is a large retailer of snow skis. The company assembled the information shown below for the quarter ended March 31: Sales.. Selling price per pair of skis. Variable selling expense per pair of skis Variable administrative expense per pair of skis Total fixed selling expense.. Total fixed administrative expense Beginning merchandise inventory. Ending merchandise inventory Merchandise purchases ..... .. Amount $150,000 $750 $50 $10 $20,000 $20,000 $30,000 $40,000 $100,000 Required: 1. Prepare a traditional income statement for the quarter ended March 31. 2. Prepare a contribution format income statement for the quarter ended March 31. 3. What was the contribution margin per unit?

xercise 5-13 - Con X + ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A %252F%252Fmycstate.cincinnatistate.edu%252Fwebapps i Miller Company's contribution format income statement for the most recent month is shown below: Per Unit $ 8.00 5.00 $ 3.00 Sales (34,000 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 272,000 170,000 Required: (Consider each case independently): 102,000 47,000 $ 55,000 1. What is the revised net operating income if unit sales increase by 19%? 2. What is the revised net operating income if the selling price decreases by $1.40 per unit and the number of units sold increases by 16%? 1. Net operating income 2. Net operating income 3. Net operating income 4. Net operating income 3. What is the revised net operating income if the selling price increases by $1.40 per unit, fixed expenses increase by $6,000, and the number of units sold decreases by 5%? $ 4. What is the revised net…

dit J... View History es 2 Chapter 5 Assignment i Men | Ethika | With You... Bookmarks 2 F2 W O 1. Contribution margin ratio 2. Estimated change in net operating income # 3 Window Help Thank you for your pur... 80 F3 E Last month when Holiday Creations, Incorporated, sold 41,000 units, total sales were $164,000, total variable expenses were $137,760, and fixed expenses were $37,300. Required: 1. What is the company's contribution margin (CM) ratio? 2. What is the estimated change in the company's net operating income if it can increase sales volume by 575 units and total sales by $2,300? (Do not round intermediate calculations.) $ 4 30 a F4 R % 5 % ezto.mheducation.com UO iets frans... Embroidere.... Ⓒ F7 U * DII F8 ( 59 M Question 4 - ACC 202... I O 9 Help Save F9 ) To

Allocate a retailer’s purchasing department’s costs of $20,000 to its operating departments using each department’s percentage of total purchase orders.

ndow Help mework.pdf Aa v Question 5 You have been recently hired as general manager of Lucky's. It is September 1, and you must prepare the operating budget of this establishment for the first quarter of the upcoming calendar year, and submit it to the corporate office. Since you have been at the operation for only a month or so, you must rely solely on historical data. You gather sales reports and records for the months of January through August of the current year. Using the data provided, prepare the operating budget for Lucky's for the months of January through March of the upcoming year. Here is the information you determined from the most recent sales and costs records: Sales are 10 percent higher than those of the same month during the previous year. Food cost percentage is steady at 32 percent. Fixed labor costs are steady at $9,000 per month. Variable labor costs are 15 percent of sales. Occupancy costs will remain steady at $2,000 per month. Other controllable costs are…