How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

PROJECT A - Case 9-30 Student Name: SALES

Customer Question

PROJECT A - Case 9-30
Student Name:


SALES BUDGET:
April May June Quarter
Budgeted unit sales
Selling price per unit
Total Sales


SCHEDULE OF EXPECTED CASH COLLECTIONS:
April May June Quarter
February sales
March sales
April sales
May sales
June sales
Total Cash Collections


MERCHANDISE PURCHASES BUDGET:
April May June Quarter
Budgeted unit sales
Add desired ending inventory
Total needs
Less beginning inventory
Required purchases
Cost of purchases @ $4 per unit


BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES:
April May June Quarter
Accounts payable
April purchases
May purchases
June purchases
Total cash payments


EARRINGS UNLIMITED
CASH BUDGET
FOR THE THREE MONTHS ENDING JUNE 30
April May June Quarter
Cash balance
Add collections from customers
Total cash available

Less Disbursements
Merchandise purchases
Advertising
Rent
Salaries
Commissions
Utilities
Equipment purchases
Dividends paid
Total Disbursements

Excess (deficiency) of receipts
over disbursements
Financing:
Borrowings
Repayments
Interest
Total financing

Cash balance, ending


EARRINGS UNLIMITED
BUDGETED INCOME STATEMENT
FOR THE THREE MONTHS ENDED JUNE 30

Sales -
Variable expenses:
Cost of goods sold -
Commissions - -
Contribution Margin -
Fixed expenses:
Advertising -
Rent -
Salaries -
Utilities -
Insurance -
Depreciation - -
Net operating income -
Interest expense -
Net income -


EARRINGS UNLIMITED
BUDGETED BALANCE SHEET
JUNE 30

Assets:

Cash
Accounts receivable (see below)
Inventory
Prepaid insurance
Property and equipment, net
Total assets


Liabilities and Stockholders' Equity

Accounts payable, purchases
Dividends payable
Capital stock
Retained earnings (see below)
Total liabilities and stockholders' equity


Accounts receivable at June 30:
May sales x ?%
June sales x ?%
Total


Retained earnings at June 30:
Balance, March 31
Add net income
Total
Less dividends declared
Balance, June 30

Clark Paints: The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the paint cans instead of purchasing them. The equipment needed would cost $200,000, with a disposal value of $40,000, and it would be able to produce 5,500,000 cans over the life of the machinery. The production department estimates that approximately 1,100,000 cans would be needed for each of the next five years.

The company would hire three new employees. These three individuals would be full-time employees working 2,000 hours per year and earning $12.00 per hour. They would also receive the same benefits as other production employees, 18% of wages, in addition to $2,500 of health benefits.

It is estimated that the raw materials will cost 25¢ per can and that other variable costs would be 5¢ per can. Since there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted.

It is expected that cans would cost 45¢ each if purchased from the current supplier. The company's minimum rate of return (hurdle rate) has been determined to be 12% for all new projects, and the current tax rate of 35% is anticipated to remain unchanged. The pricing for a gallon of paint, as well as the number of units sold, will not be affected by this decision. The unit-of-production depreciation method would be used if the new equipment is purchased.

Required:
1. Based on the above information and using Excel, calculate the following items for this proposed equipment purchase:
o Annual cash flows over the expected life of the equipment
o Payback period
o Annual rate of return
o Net present value
o Internal rate of return

2. Would you recommend the acceptance of this proposal? Why or why not? Prepare a short double-spaced Word paper elaborating and supporting your answer.

Can I get this project for November 20, 2011 the template above is what I have to use
Thank you Jawaad
Submitted: 2 years ago.
Category: Homework
Expert:  Linda_us replied 2 years ago.
Hi JACUSTOMER

Do you want to solution to Clark Paints or the question posted before it or both?

Also for the first question no information is given. Please Check?

Regards

Linda
Customer: replied 2 years ago.

both also there is a temp plate excel that I send it has to be in formulas I could not get to paste the temp plate as it suppose to be I had tocopy and paste.

The temp plate excel is the first and the Clark Paints is the actual problem but has to do in the temp plate formula if you understand.

Expert:  Linda_us replied 2 years ago.
I am sorry, I will opt out and let other experts help you with this.

Regards

Linda
Expert:  Manal Elkhoshkhany replied 2 years ago.

Hello

 

Please upload the excel template to www.mediafire.com then copy and paste the share link here. It is also better to upload the problems in a word document so that the questions are properly formatted, but please note that the amount you are offering is too low for the work involved so consider either increasing the offer, or offering a bonus to compensate for all the work involved

 

Thank you

Customer: replied 2 years ago.

Just do Project B but has to be done in excel with formulas.

thank you and sorry that is with clark paints.

thank you I appreciate your help.

Expert:  Manal Elkhoshkhany replied 2 years ago.

Working on the question. Please advise your deadline

 

Thank you

Customer: replied 2 years ago.
the dead line is Sunday November 20, 2011 and please do not do Project A only PROJECT B with Clark Paints
Expert:  Manal Elkhoshkhany replied 2 years ago.

Oh, I thought you wanted Project A

 

Ok, please upload the excel template you have for project B to www.mediafire.com then copy and paste the share link here

Customer: replied 2 years ago.
I am unable to upload the template on media fire it gave my laptop a virus which cause my laptop to crash one me. I just got back my lap top from an IT person.
Customer: replied 2 years ago.

I am unable to upload the template on media fire it gave my laptop a virus which cause my laptop to crash one me. I just got back my lap top from an IT person. I send the template to justanswer email address together with the materials for Project A.

 

Also Project B Clark Paints has to be use in a excel showing all formulas.

Expert:  Manal Elkhoshkhany replied 2 years ago.

I apologize I cannot help without the template. I also got very busy so it would be hard to complete the assignment as I committed to other assignments when you have not responded to me. I have opted out in case another expert can help

 

All the best

Customer: replied 2 years ago.

CASE 9-30 Master Budget with Supporting Schedules [LO2, LO4, LO8, LO9, LO10]

 

You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash.

Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the benefits that can be gained from an integrated budgeting program. To this end, you have worked with accounting and other areas to gather the information assembled below.

The company sells many styles of earrings, but all are sold for the same price-$10 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings):

 

 January (actual) .... . 20,000 June (budget) 50,000 February (actual) .... 26,000 July (budget) . 30,000 March (actual) 40,000 August (budget) 28,000 April (budget) 65,000 September (budget).... . 25,000 May (budget) . 100,000

 

It has to do in excel with formulas showing. Jawaad can you please help me I need both projects by 11/22/11.

Customer: replied 2 years ago.

Project A - Case 9-30 has to do in excel showing all formulas.

Thank you Jawaad

This template is how it suppose to be I could not get to copy the template right.

 

PROJECT A - Case 9-30
SALES BUDGET:
AprilMayJuneQuarter
Budgeted unit sales
Selling price per unit
Total Sales
SCHEDULE OF EXPECTED CASH COLLECTIONS:
AprilMayJuneQuarter
February sales
March sales
April sales
May sales
June sales
Total Cash Collections
MERCHANDISE PURCHASES BUDGET:
April May June Quarter
Budgeted unit sales
Add desired ending inventory
Total needs
Less beginning inventory
Required purchases
Cost of purchases @ $4 per unit
BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES:
April May June Quarter
Accounts payable
April purchases
May purchases
June purchases
Total cash payments
EARRINGS UNLIMITED
CASH BUDGET
FOR THE THREE MONTHS ENDING JUNE 30
April May June Quarter
Cash balance
Add collections from customers
Total cash available
Less Disbursements
Merchandise purchases
Advertising
Rent
Salaries
Commissions
Utilities
Equipment purchases
Dividends paid
Total Disbursements
Excess (deficiency) of receipts
over disbursements
Financing:
Borrowings
Repayments
Interest
Total financing
Cash balance, ending
EARRINGS UNLIMITED
BUDGETED INCOME STATEMENT
FOR THE THREE MONTHS ENDED JUNE 30
Sales -
Variable expenses:
Cost of goods sold -
Commissions - -
Contribution Margin -
Fixed expenses:
Advertising -
Rent -
Salaries -
Utilities -
Insurance -
Depreciation - -
Net operating income -
Interest expense -
Net income -
EARRINGS UNLIMITED
BUDGETED BALANCE SHEET
JUNE 30
Assets:
Cash
Accounts receivable (see below)
Inventory
Prepaid insurance
Property and equipment, net
Total assets
Liabilities and Stockholders' Equity
Accounts payable, purchases
Dividends payable
Capital stock
Retained earnings (see below)
Total liabilities and stockholders' equity
Accounts receivable at June 30:
May sales x ?%
June sales x ?%
Total
Retained earnings at June 30:
Balance, March 31
Add net income
Total
Less dividends declared
Balance, June 30
Customer: replied 2 years ago.

THIS IS THE REST OF PROJECT A

THANK YOU

Customer: replied 2 years ago.

CASE 9-30 Master Budget with Supporting Schedules [LO2, LO4, LO8, LO9, LO10]

 

You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash.

Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the benefits that can be gained from an integrated budgeting program. To this end, you have worked with accounting and other areas to gather the information assembled below.

The company sells many styles of earrings, but all are sold for the same price-$10 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings):

 

January (actual) 20,000

February (actual) 26,000

March (actual) 40,000

April (Budget) 65,000

May (Budget) 100,000

June (Budget) 50,000

July (Budget) 30,000

August (Budget) 28,000

September (Budget) 25,000

 

Project A - Case 9-30 has to do in excel showing all formulas.

This template is how it suppose to be I could not get to copy the template right.

 

PROJECT A - Case 9-30
SALES BUDGET:
AprilMayJuneQuarter
Budgeted unit sales
Selling price per unit
Total Sales
SCHEDULE OF EXPECTED CASH COLLECTIONS:
AprilMayJuneQuarter
February sales
March sales
April sales
May sales
June sales
Total Cash Collections
MERCHANDISE PURCHASES BUDGET:
April May June Quarter
Budgeted unit sales
Add desired ending inventory
Total needs
Less beginning inventory
Required purchases
Cost of purchases @ $4 per unit
BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES:
April May June Quarter
Accounts payable
April purchases
May purchases
June purchases
Total cash payments
EARRINGS UNLIMITED
CASH BUDGET
FOR THE THREE MONTHS ENDING JUNE 30
April May June Quarter
Cash balance
Add collections from customers
Total cash available
Less Disbursements
Merchandise purchases
Advertising
Rent
Salaries
Commissions
Utilities
Equipment purchases
Dividends paid
Total Disbursements
Excess (deficiency) of receipts
over disbursements
Financing:
Borrowings
Repayments
Interest
Total financing
Cash balance, ending
EARRINGS UNLIMITED
BUDGETED INCOME STATEMENT
FOR THE THREE MONTHS ENDED JUNE 30
Sales -
Variable expenses:
Cost of goods sold-
Commissions- -
Contribution Margin-
Fixed expenses:
Advertising-
Rent-
Salaries-
Utilities-
Insurance-
Depreciation- -
Net operating income-
Interest expense -
Net income-
EARRINGS UNLIMITED
BUDGETED BALANCE SHEET
JUNE 30
Assets:
Cash
Accounts receivable (see below)
Inventory
Prepaid insurance
Property and equipment, net
Total assets
Liabilities and Stockholders' Equity
Accounts payable, purchases
Dividends payable
Capital stock
Retained earnings (see below)
Total liabilities and stockholders' equity
Accounts receivable at June 30:
May sales x ?%
June sales x ?%
Total
Retained earnings at June 30:
Balance, March 31
Add net income
Total
Less dividends declared
Balance, June 30

 

 

 

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3121
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3035
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/lanis/2009-4-1_233717_phput9xef_c1pm.jpg Lani S.'s Avatar

    Lani S.

    Tutor

    Satisfied Customers:

    2457
    Registered Nurse, Internet Researcher, Private Tutor
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2341
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1975
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1873
    Bachelors Degree and CPA with Accounting work experience