Determine sales revenue and net income, Cost Accounting

Students will prepare a Comprehensive Master Budget and Budgeted Financial Statements for Earrings Unlimited for the three-month period ending June 30. This includes: Sales Budget, Cash Receipts Budget, Merchandise Purchases Budget, Cash Disbursements Budget, Cash Budget, Budgeted Income Statement using the Contribution Format, and a Budgeted Balance Sheet. Students will also perform CVP analysis to determine the break-even point and complete a sensitivity analysis to a sales price change and a change in the price of purchases.

Project Requirements:

I. Complete the Earrings Unlimited Case on an individual basis using the Excel template found on Blackboard under Course Documents, Project. Enter your answer on the Worksheet labeled "Part I Answer." Use formulas in the cells for calculations (i.e., do not type in a total that you have determined with your calculator.)

II. Use CVP Analysis to determine the break-even point in units and sales dollars for Earrings Unlimited for the Quarter Ended June 30. You must show all calculations. Enter your response on the Project Excel file in the Worksheet labeled "Part II Answer."

III. Determine Sales Revenue & Net Income for the 3-month period ending June 30, and the ending Cash Balance as of June 30 assuming the unit Sales Price is expected to increase (effective April 1) to $12, and the unit Purchase Price is expected to increase (effective April 1) to $5. Reconcile the changes.

To solve this, use the Worksheets provided in the Project Excel file (i.e., the worksheets titled "If SP = $12," "If Purch Pr = $5," "If SP=$12; and Purch Pr = $5" ). In each Worksheet, start with the Base Case data (what you entered as "Part I Answer") and then change the budget and/or financial statement data affected by the change to the Sales Price and/or the change to the Purchases Price. For example, changing the unit sale price will cause changes to the sales budget, cash receipts budget, and summary cash budget... this will lead to a new Net Income and a new June 30 ending Cash Balance. With changes to Sales and/or Purchases Prices, items such as interest expense and inventory values will also change. Complete the chart found on the Project Excel file in the Worksheet labeled "Part III Answer."

Hint: If you have used formulas for all calculations in the Excel spreadsheet, this question will be simple.

Another Hint: In the Base Case (Part I) and in the scenarios in Part III, be careful to follow the rules that Earrings Unlimited has established with its bank with respect to taking out and repaying loans as this will impact other items.

Posted Date: 2/21/2013 4:46:27 AM | Location : United States

Related Discussions:- Determine sales revenue and net income, Assignment Help, Ask Question on Determine sales revenue and net income, Get Answer, Expert's Help, Determine sales revenue and net income Discussions

Write discussion on Determine sales revenue and net income
Your posts are moderated
Related Questions
what is the implication of applying accounting principle wrongly

The Accountant has also asked for you to assist in preparing the statement of financial position (balance sheet) for the Construction in Building partnership for the year ended 30

MARGINAL COSTING Vs DIRECT COSTING Direct costing is the method where only direct costs are measured while calculating the cost of the product. Indirect costs are met in opposi

Chrome-It, Inc., manufactures special chromed parts made to the order and specifications of the customer.  It has two production departments, stamping and plating, and two service

TYPES OF VARIANCES Variances are computed for the entire three basic elements of cost - direct labour, direct material, and overhead variance 1. Direct labour variance 2.

Bugga Corp expects to sell 3,000 units in October, and expects sales to increase 20% each month thereafter. Sales price is expected to stay constant at $8 per unit. What are budge

You are assisting the accountant on the preparation of the final accounts of a business with a year-end of 31 December. A trial balance has been drawn up and a suspense account ope

The activity driver for the shipping activity is the number of orders shipped. Product A uses 20 orders and Product B uses 60 orders. Calculate the consumption ratios for each prod

Lapsol limited manufacture electrical appliances for the export market. The management of the company are considering investing in one of two possible capital expenditure projects.

A listed entity, had 3,000,000 $1 ordinary shares in issue, On 1 January 2009 CSA.CSA made a bonus issue of 1 for 3, On 1 May 2009. CSA issued 2,000,000 $1 ordinary shares for $3.2