Given the information below, calcu SALES Food Beverage Total Sales COST OF SALES Food Beverage Total Cost of Sales LABOR Management Staff Employee Benefits Total Labor Cost PRIME COST OTHER CONTROLLABLE EXPENSES Direct Operating Expenses Utilities, Repair, Maintenance Total Other Controllable Expenses CONTROLLABLE INCOME This Month $1,110,500 333,150 $1,443,650 $335,926 93,282 $429,208 $186,626 93,469 30,845 $310,940 $740,148 $71,000 45,492 $115,492 % of sales

Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended December 31 are as follows: Salesperson Total Sales Variable Cost of Goods Sold Variable Selling Expenses Case $612,000   $336,600     $85,680     Dix 384,000   215,040     84,480     Johnson 461,000   225,890     101,420     LaFave 460,000   147,200     101,200     Orcas 399,000   131,670     51,870     Sussman 427,000   217,770     59,780     Willbond 439,000   184,380     70,240     Required: 1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. Round percents to the nearest whole number. Enter all amounts as positive numbers. Waltham Industries Inc.Salespersons' AnalysisFor the Year Ended December…

ulcan Company's contribution format income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales Variable expenses Contribution margin Fixed expenses Net operating income $ 900,000 408,000 492,000 455,000 $ 37,000 Management is disappointed with the company's performance and is wondering what can be done to improve profits. By examining sales and cost records, you have determined the following: a. The company is divided into two sales territories-Northern and Southern. The Northern Territory recorded $400,000 in sales and $208,000 in variable expenses during June; the remaining sales and variable expenses were recorded in the Southern Territory. Fixed expenses of $164,000 and $125,000 are traceable to the Northern and Southern Territories, respectively. The rest of the fixed expenses are common to the two territories. b. The company is the exclusive distributor for two products-Paks and Tibs. Sales of Paks and Tibs totaled $150,000 and…

Kindly help and not handwritten

Calculate the Return on Investment from the following responsibility report data using total revenue as the base: Responsibility report data Account Actual Revenues Clothing revenue $473,158 Clothing accessories revenue 18,757 Expenses Associates wages $41,704 Managers wages 22,906 Cost of clothing sold 254,631 Cost of accessories sold 5,969 Equipment/fixture repairs 960 Utilities 1,539 Round to two decimal places. Be sure to enter the answer as a percentage but do not include the % sign.

4

Mach Co. operates three manufacturing departments as profit centers. The following information is available for its most recent year: Dept. Sales 1 2 3 $1,100,000 430,000 710,000 Cost of goods sold $735,000 156,500 305,000 Direct expenses Indirect expenses $110,000 $85,000 40,200 105,000 165,000 21,000 Which department has the greatest departmental contribution to overhead and what is the amount contributed? Group of answer choices Dept. 3; $430,000 Dept. 1; $255,000 Dept. 2; $110,000 Dept. 3; $240,000 Dept. 2; $156,500

can you show work and show how to do it in excel?

10:20 (Feb 21-27) Food Cost 044 Beverage Cost Labor Cost Other Costs Total Costs Food Sales Beverage Sales Total Sales (Revenue) Total Profit • N Projected $6,971 $3,954 $8,423 $7,645 $26,993 $18,565 $12,872 $31,437 $4,444 56% السم Based on the actual results, what adjustments need to be made to Food and Beverage sales projections for next week? O b. Projections for next week should be increased to make up the difference from this week Actual $7,842 $4, 156 $9,541 $7,645 $29, 184 $14,326 $10,852 $25,178 -$4,006 O a. Projections for next week should be set the same as this week, so we can strive to reach our goals. O d. Projections for next week should be increased because we exceeded our projections this week ||| O O c. Because this week's actual profit (-$4006) came in below our projected profit ($4444), we should reduce next week's Food and Beverage sales projections.

Analyzing profitability analysis, service company Burlington Internet Services is an Internet service provider for commercial and residential Customers. The company provided the following data for its two types of customers for the month of August: For each type of customer, determine both the contribution margin per customer and the contribution margin ratio. Round to twos decimal places. Which type of service and more profitable?