Create a multiple-line chart of the total sales per month of each model, standard and deluxe.800 000800000800 000Standard-Standard-StandardDeluxeDeluxeDeluxe700000700000700 000600 000600000600 000500 000500 000500 000400 000400000400 000300000300000300 000JanFebMarAprMayJunJanFebMarAprМayJunJanFebMarAprMayJunMonthMonthMonth800 000StandardDeluxe700000600 000500000400000300 000JanJanFebMarAprМayJunMonthSales ($)Sales ($)Sales ($)Sales ($) As the sales manager for a company manufacturing and selling standard and deluxe computer components, you have been asked by the president to prepare the following chart for the shareholders' meeting next week. Use the six-month sales report below as the database. Calculate totals as required.JanuaryFebruaryMarchАprilMayJuneStandardDeluxeStandardDeluxeStandardDeluxeStandardDeluxeStandardDeluxeStandardDeluxeNorthwest$121,200$85,400$113,800$72,700$131,400$90,100$134,700$91,600$110,900$64,300$133,000$77,400Northeast$214,700$121,300$228,400$133,100$246,600$164,800$239,000$153,200$266,100$185,000$279,300$190,100Southwest$88,300$49,000$72,100$43,700$97,700$56,300$104,000$65,800$125,000$76,300$130,400$72,500Southeast$144,200$89,700$150,900$92,300$159,400$95,500$128,700$71,300$146,700$80,400$163,000$89,600

Chart is created with monthly sales total of each model in excel.

Iine chart of the tot sales per mo hth of each model, standard 800000 800000 800000 Standard Standard Deluxe Deluxe 700000 700000 700000 600000 600 000 600000 500000 500000 500000 Sales ($) Sales ($) Sales ($)

Iine chart of the tot sales per mo hth of each model, standard 800000 800000 800000 Standard Standard Deluxe Deluxe 700000 700000 700000 600000 600 000 600000 500000 500000 500000 Sales ($) Sales ($) Sales ($)

PAYROLL ACCT.,2019 ED.(LL)-TEXT

19th Edition

ISBN:9781337619783

Author:BIEG

Publisher:BIEG

Chapter1: The Need For Payroll And Personnel Records

Section: Chapter Questions

Problem 4QD: The main office of a large bank has an annual turnover of 500 office workers. As an employment...

See similar textbooks

Similar questions

Classify each of the following actions as either being associated with the financial accounting information system (FS) or the cost management information system (CMS): a. Determining the total compensation of the CEO of a public company b. Issuing a quarterly earnings report c. Determining the unit product cost using TDABC d. Calculating the number of units that must be sold to break even e. Preparing a required report for the SEC f. Preparing a sales budget g. Using cost and revenue information to decide whether to keep, or drop, a product line h. Preparing an annual statement of financial position that conforms to generally accepted accounting principles (GAAP) i. Using cost and revenue information to decide whether to invest in a new production system or not j. Reducing costs by improving the overall quality of a product k. Using a debt-equity ratio and liquidity ratios from a balance sheet to assess the likelihood of bankruptcy l. Using a public companys financial statements to decide whether or not to buy its stock
t is the last day of the month and fiscal year, your manager asks you to create an invoice for $10,000 (debiting Accounts Receivable and Crediting Sales) and send it to a specified customer. Normally invoices are sent to customers when products have been shipped or the service has been finished. You manager tells you that we will be shipping equipment and performing the setup services for this customer next month (as early as next week). You know that by preparing the closing entries tomorrow, the revenue will be included in this year’s fiscal year and then the revenue account will be set to zero for the beginning of the year. How would you respond to your manager? Do you have any suggestions or alternative ways you would recommend to your manager on how to record this?
It is the last day of the month and fiscal year, your manager asks you to create an invoice for $10,000 (debiting Accounts Receivable and Crediting Sales) and send it to a specified customer. Normally invoices are sent to customers when products have been shipped or the service has been finished. You manager tells you that we will be shipping equipment and performing the setup services for this customer next month (as early as next week). You know that by preparing the closing entries tomorrow, the revenue will be included in this year’s fiscal year and then the revenue account will be set to zero for the beginning of the year. What is your manager trying to accomplish by asking you to do this?
Directions: Show complete solutions. Take a picture of your solutions and paste in word. Submit the word file version to my email no later than 10:30am today. Thanks. Problem 1: Quarry Company, a manufacturer of small tools, provided the following information for the year ended December 31, 2020. Inventory at December 31, based on physical count – P1,750,000 Accounts payable at December 31 – P1,200,000 Net sales – P8,500,000 Additional information: Included in the physical count were tools billed to a customer FOB shipping point on December 31, 2020. These tools had a cost of P28,000 and were billed at P35,000. The shipment was in loading dock waiting to be picked up by the common carrier. Goods in transit from a vendor to Quarry Company on December 31, 2020. The invoice cost was P50,000 and the goods were shipped FOB shipping point on December 29, 2020. Work in Process inventory costing P20,000 was sent to an outside processor for plating on December 30, 2020. Tools returned by…
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
Sara is considering whether to open a gadgets shop. She provided you, as a consultant, the following information: Sales of $60,000 and $72,000 are expected for July and August, respectively. All goods are sold on account. The collection pattern for Accounts Receivable is 80 percent in the month of sale and 20 percent in the month following the sale. Purchases of $40,000 and $54,000 are expected for July and August. The payment pattern for purchases is 70 percent in the month of purchase, 30 percent in the month following the purchase. Other monthly expenses are $8,000, which includes $2000 of depreciation. All operating expenses are paid in the month of their incurrence. $2,000 of cash is available on August 1, 2021. Required: Prepare the cash collection budget for the two months ending August 31, 2021 Prepare the cash budget for the two months ending August 31, 2021
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
Aston Corporation performs year-end planning in November of each year before its calendar year ends in December. The preliminary estimated net income is $4,800,000. The CFO, Rita Warren, meets with the company president, J. B. Aston, to review the projected numbers. She presents the following projected information. Aston Corporation Projected Income Statement For the Year Ended December 31, 2020 Sales $28,995,000 Interest revenue 5,000 Cost of goods sold $14,000,000 Depreciation 2,600,000 Operating expenses 6,400,000 23,000,000 Income before income tax 6,000,000 Income tax 1,200,000 Net income $ 4,800,000 Aston Corporation Selected Balance Sheet Information At December 31, 2020 Estimated cash balance $ 5,000,000 Available-for-sale debt investments (at cost) 10,000,000 Fair value adjustment (1/1/20) —0— Estimated fair value at December 31, 2020: Security Cost…
The financial manager at the LOL shop is checking to see if there is any relationship between online advertising and sales revenues at the shop. She ob- tains the following data for the past 10 months: Month: Revenues: Advertising Costs: March $51.000 $1.500 April $72.000 $3.500 May $56.000 $1.000 June $64.000 $4.000 July $57.000 $ 500 August $64.000 $1.500 September $43.000 $1.000 October $82.000 $4.500 November $56.000 $2.000 December $61.000 $2.000 Required: 1. Use the high-low method to compute the function relating advertising costs and revenues 2. Using the high-low equation, what is the increase in revenues for each $ 1 000 spent on advertising within the relevant range?
Book: Sales Management: Shaping future sales leaders, 2nd edition: by Tanner, Honeycutt, and Erffmeyer. ASSESSING THE PERFÓRMANCE OF THE SALES FORCE AND THE PEOPLE WHO COMPRISE IT Questions and Problems 8. If a salesperson received 32 purchase orders during the month based upon 123 sales calls, what is his order per call, or "close rate"?.
In the file MajorSalary, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students majoring in management, finance, accounting, information systems, and marketing. Create a PivotTable in Excel to display the number of graduates in each major and the average monthly starting salary for students in each major. a. Which major has the greatest number of graduates? b. Which major has the highest average starting monthly salary? c. Use the PivotTable to determine the major of the student with the highest overall starting monthly salary. What is the major of the student with the lowest overall starting monthly salary?