Quarterly cash payments budget, Financial Accounting

Assignment Help:

Emily Jackson, RSC Designs management accountant, is in charge of preparing the master budget for 2013.  She has gathered the following information:

1. Annual profit for the 2012/2013 financial year is expected to be the sum of  each group members RMIT student number.  The split (anticipated sales mix)  between SML Sculptures and LGE Sculptures is for every 3 LGE sculptures sold 2 SML Sculptures will be sold.  Forty percent (40%) of the total sales (of each product) will occur in the first 6 months of the financial year and the remaining sixty percent (60%) will occur in the remaining six months. 

Expected sales for the final quarter of 2012 are expected to be 15,000 units of the SML Sculptures and 23,000 of the LGE Sculptures.

2. RSC Designs' sales history indicates that 40 percent of all sales are on credit, with the remainder of the sales being on a cash basis.  The company's collection experience shows that 60 percent of the credit sales are collected during the quarter in which the sale is made, while the remaining 40 percent is collected in the following quarter.  (For simplicity, assume the company is able to collect 100 percent of its accounts receivable.)

3. The SML sculpture has a selling price of $45 per unit, and the LGE sculpture has a selling price of $75 per unit.  These prices are expected to hold constant throughout the 2012/2013 financial year.  

4. The production manager attempts to end each quarter with enough finished - goods inventory in each product line to cover 20 percent of the following  quarter's sales.  Moreover, an attempt is made to end each quarter with 20 percent of the glass sheets needed for the following quarter's production.  As the metal strips are purchased locally the company buys them on a just-in-time
basis, and as a result the inventory is negligible.

5. All direct material purchases are made on credit, with 80 percent of each quarter's credit purchases being paid in cash during the same quarter as the purchase.  The remaining 20 percent is paid in the next quarter.

6. Indirect materials are purchased on a cash basis as needed.  Work-in-process is negligible.


Related Discussions:- Quarterly cash payments budget

Quarterly cash dividends are planned, Given the information that follows, d...

Given the information that follows, draw a cash budget for the XYZ Store for the first six months of 2012. Every prices and costs remain constant. Sales are 80% for credit

Writing a dissertation, I want to do a custom dissertation on IAS 40 invest...

I want to do a custom dissertation on IAS 40 investment property which needs to include a brief outline, positive as well as negative international critique with respect to the sta

Looking for income statement and balance sheet, Looking for Income Statemen...

Looking for Income Statement and Balance Sheet for the Better USA, Inc. company for 2010 and 2011 Facts: Sales 11,573 (2010) and 12,936 (2011) - Depreciation 1,661 and 1,736 - Cost

Compute the total amount of dividends that was paid to each, Vantage Compan...

Vantage Company issued bonds with a $500,000 face value and a 6% stated rate of interest on January 1, 2013. The bonds carried a 5-year term and sold for 95. Vantage uses the strai

Show the calculations and journal entries to record, Company A subsequently...

Company A subsequently sells 60% of the voting interest in Company S for $900,000. The fair value of Company A's retained interest of 10% in the voting stock in Company S is $120,0

Capita expenditure and revenue expenditure, The company selected a suitable...

The company selected a suitable site and commissioned a survey and valuation report, for which the fee was £1,500. On the basis of the report the site was acquired for £90,000. Sol

UNDERSTANDING bUSINESS, I NEED HELP in business ratios for two company.Ido...

I NEED HELP in business ratios for two company.Ido not know how to do the formulas. Can you help.

Basic interest rate and maximum interest rate, Suppose a risk neutral agent...

Suppose a risk neutral agent has $100,000 today that he wants to save for one year. Compare the following two savings plans. Bank A offers a standard savings account with 4% p.a

Cost of Loan, Given information: Offered a $20 million commercial loan pri...

Given information: Offered a $20 million commercial loan priced using a 3month LIBOR index+100bp. After some preliminary research, using a money center bank''s swap trading desk

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