05 Jun Project briefing for the Bishop Company
Question
Project briefing for the Bishop Company
This project is based upon the “Bishop Company” question ATC 3-6 from the textbook (p. 147-148). Prepare an Excel spreadsheet as it appears in the text book.
As the source data (i.e. selling price, variable cost per unit, fixed costs and units sold) will change on a monthly basis, you should use formulas to automatically calculate the following values for the income statement and cost-volume-profit analysis:
• Sales
• Variable costs
• Contribution margin
• Fixed costs
• Net income
• Break even (in units)
• Operating leverage
If your formulas are correct, you should only have to enter the source data in cells D4-D8 as all other figures will be calculated automatically.
As of 1 January 2011, the company plans to purchase certain components from outside suppliers rather than manufacturing them internally. As a result, it is forecast that fixed production costs per will decrease to $40,000 per month and the variable cost per unit will rise to $15 per unit. Bishop’s forecast performance for January 2011 is as follows:
• Selling price per unit $18
• Variable cost per unit $15
• Fixed costs $40,000
• Units sold 20,000
Required:
a) Extend your existing spreadsheet by preparing an income statement, break even and operating leverage calculations for the new January 2011 data. Locate this new analysis to the right of your December data in columns F to G. As the January data uses an identical format to December, you can copy your existing cells to columns F to G, then modify and re-date as needed. You will have to adjust the size of columns F-G to display the new data correctly. You should also go to “page layout” and change the “orientation” of your page to “landscape”.
b) Using the monthly data for December 2010 and January 2011, add a worksheet section that provides revised calculations for each month’s break even and net income figures assuming the selling price achieved is revised to $10, $16, $25 or $45 per unit.
a) At an appropriate place on your worksheet, provide a brief written assessment (no more than 400 wo
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.