Determine sales revenue and net income, Cost Accounting

Assignment Help:

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.


Related Discussions:- Determine sales revenue and net income

Identify the income statement and balance sheet, In January 2012, the manag...

In January 2012, the management of Stefan Company concludes that it has sufficient cash to permit some short-term investments in debt and stock securities. During the year, the fol

Definitions of manufacturing concepts interstate, Definitions of manufactur...

Definitions of manufacturing concepts  Interstate Manufacturing produces brass fasteners and incurred the following costs for the year just ended:  Materials and supplies used

Allocation of overhead costs, Allocation of Overhead Costs Allocation ...

Allocation of Overhead Costs Allocation of overheads is the term utilized where the overhead cost item can be charged to a exact cost center without the requirement for any es

Calculate the annual percentage rate, Amanda Deal, president of XYZ, had re...

Amanda Deal, president of XYZ, had recently finished an arduous round of meetings with her financial staff". Those meetings dealt with the details necessary to produce an accurate

Calculate the variable cost, Workmen shoes accumulated the following produc...

Workmen shoes accumulated the following production and cost data for the past 5 months. i)  Using the high/low method calculate the variable cost per unit and the fixed cos

Overapplied or underapplied overhead: manufacturer, Budgeted direct labour ...

Budgeted direct labour cost 75000 hours @ $16 per hour Budgeted manufacturing overhead 80 000 hours @ $17.50 per hour Actual direct labour cost $997 500 Budgeted manufa

Cost estimation, Cost Estimation  Cost estimation may be defined with...

Cost Estimation  Cost estimation may be defined with 'a study that attempts to predict among costs and the activity level or cost driver that causes those costs. In practical

Difference between expenses and expenditure, The difference among expenses ...

The difference among expenses and expenditure. Expense is the outflow from a profit oriented organization whereas expenditure is the outflow from non-profit organization.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd