Wrtie a program to read this list of prices and the sales table and calculate the total dollar sales for each salesperson and the total dollar sales for all salespersons.
Solution Summary
Creates a program to read a list of prices and a table of sales.
The program then calculates the total sales in dollar for each salesperson and the total sales in dollar for all salespersons.
Includes two input files:
a) Table of auto price
b) Table of Sales persons
Following this balance sheet for 2006
Assets
Cash $15,000
Accounts Receivable 90,000
Inventory 60,000
Current Assets $165,000
Fixed Assets 60,000
Total Assets $225,000
Liabi
Ten firms complete in a market to sell product X. The totalsales of all firms selling the product are $1 million. ranking the firms' sales from highest to lowest, we find the top four firms' sales to be $175,000, $150,000, $125,000, and $100,000, respectively. Calculate the four-firm concentration ratio in the market for produc
A company has a product line that includes five items that sell for $100, $75, $120, $150, and $35. There are four salespersons working for this company, and the following report is for a given week:
Salesperson
Item Number
1 2
Please consider the following data for the Monarch Escrow Company:?
Master Budget Data:
Sales, 2,500 clients at $35 each.
Variable Costs, $25 per client.
Total Fixed Costs - $15,000.
Actual Results at Actual Prices:
Sales, 3,000 clients at $36 per clients.
Total Variable Costs - $80,000.
Total Fixed Costs - $15,7
Application
Use of Excel to Perform Calculations
Spreadsheets are extremely useful for performing various types of number crunching. Spreadsheets are also good at graphically presenting data, such as bar charts and pie charts.
In this Application, you will enhance a simple spreadsheet that contains sales data for several sa
Please help with this question.
Calculation: In the month of January, Reliance® Auto sold 60 vehicles and had account receivable of $160,000.00. If a vehicle costs $40,000, account payable is $240,000 and the cost of sales is 72%, and the current value of total inventory is $500,000.00, Calculate;
Please show all work for
Rapid Auto has over 200 auto-maintenance service outlets nationwide. It provides primarily two lines of service: oil changes and brake repair. Oil change-related services represent 63% of its salesand provide a contribution margin ratio of 20%. Brake repair represents 37% of its salesand provides a 60% contribution margin rati
Please see the attached file for better tableformat.
) Fill in the missing values in following ANOVA table
Source df SS MS F
Factor 346.2 115.4 20.79
Error 16
Total
Answer
a. In the above ANOVA table, is the factor significant at 5% level of significant?
4) A regression model relating x, number of sal
