Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare a selling and administrative expenses budget for Screenshot Tops, Inc. for the year ending December 31, 20xx. Screenshot Tops, Inc. Selling and Administrative Expenses

Prepare a selling and administrative expenses budget for Screenshot Tops, Inc. for the year ending December 31, 20xx. Screenshot Tops, Inc. Selling and Administrative Expenses Budget For the Year Ended December 31, 20xx Quarter 1 2 3 4 Year Variable expenses: Sales commissions Total variable expenses Fixed expenses: Advertising

Rent Sales salaries Office salaries Depreciation Property taxes and insurance Total fixed expenses Total selling and administrative expenses 9. Prepare a silk-screen overhead expenses budget for Screenshot Tops, Inc. for the year ending December 31, 20xx. Screenshot Tops, Inc. Silk-screen Overhead Expenses Budget For the Year Ended December 31, 20xx Quarter 1 2 3 4 Year Variable expenses: Ink Maintenance Utilities Graphics design Total variable expenses Fixed expenses: Rent Maintenance Utilities Graphics design Property taxes and insurance Depreciation Total fixed expenses Total silk-screen overhead Direct silk-screen hours Overhead rate per silk-screen hour 10. Using the information found in the case and the previous budgets, prepare a budgeted income statement for Screenshot Tops, Inc. for the year ended December 31, 20xx. Screenshot Tops, Inc. Budgeted Income Statement For the Year Ended December 31, 20xx Sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations Interest expense

Income before income taxes Income tax expense Net income 11. Using the information found in the case and the previous budgets, prepare a cash budget for Screenshot Tops, Inc. for the year ended December 31, 20xx. Screenshot Tops, Inc. Cash Budget For the Four Quarters Ended December 31, 20xx Quarter 1 2 3 4 Beginning cash balance Add: Receipts Collections from customers Total available cash Less: Disbursements Payments for shirt purchases Silk-screen labor Silk-screen overhead Selling and administrative expenses Payment for equipment purchase Total disbursements Excess (deficiency) of available cash over disbursements Financing Borrowings Ending cash balance 12. Using the information contained in the case and the previous budgets, prepare a budgeted balance sheet for Screenshot Tops, Inc. at December 31, 20xx. Screenshot Tops, Inc. Budgeted Balance Sheet December 31, 20xx Assets Cash Accounts receivable Shirt inventory Equipment Less: Accumulated depreciation Total assets

Liabilities and Stockholders Equity Accounts payable Notes payable Interest payable Taxes payable Total liabilities Common stock Retained earnings Total stockholders equity Total liabilities and stockholders equity 13. Using the information contained in the case and the previous budgets, a) calculate the estimated contribution margin per unit for 20xx. (Hint: Silk-screened labor and the taxes are both fixed costs.) b) Calculate the total estimated fixed costs for 20xx (including interest and taxes). c) Compute the break-even point in units and dollars for 20xx. 14. Michael is very disappointed that the company did not have an income of $25,000 for its first year of budgeted operations as he had wanted. How many shirts would the company have had to sell in order to have a pretax profit of $25,000? (Ignore changes in income tax expense.) 15. Why does the companys cash balance differ from the net income for the year? 16. Do you think it was a good idea to offer Cary a salary plus 10% of sales? Why or why not? What other thoughts do you have?

PLEASE SHOW CALCULATIONS IN EXCEL

Check Figures: Total fixed selling and admin $ 23,280 Total variable overhead $ 46,650 Income before taxes $ 24,670 Ending cash $ 20,380 Total assets $ 137,270 Your calculations/final numbers should match those above.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For MBAs

Authors: Peter D. Easton, John J. Wild, Robert F. Halsey, Mary Lea McAnally

3rd Edition

0978727932, 978-0978727932

More Books

Students also viewed these Accounting questions