Quarterly cash payments budget, Financial Accounting

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.

Posted Date: 3/15/2013 1:58:59 AM | Location : United States







Related Discussions:- Quarterly cash payments budget, Assignment Help, Ask Question on Quarterly cash payments budget, Get Answer, Expert's Help, Quarterly cash payments budget Discussions

Write discussion on Quarterly cash payments budget
Your posts are moderated
Related Questions
I have one assignment of this course (diploma Financial Planning), can you help me in doing my assignment

when youre using accounting software why would you use hot keys and shortcuts a.to quickly access commands b.to input data for you c.to start the program d.to write checks

Payback Period and Net Present Value XYZ Software, Inc., has the following mutually exclusive projects. Year Project A Project B

Please use the information below to complete Form 1120S and the Schedule K-1%u2019s for Form 1120S. Blank forms can be found on the Hands-On Assignment page or in Doc Sharing. If y

what is the different between prorfit and margin prorfi

Q. Average cost of capital? Even though the director suggests that equity finance is appropriate given the amount of finance needed the amount alone doesn't rule out other fina

Money demand in an economy in which no interest is paid on money is M d /P = 500 + 0.2Y - 1000i (a) Suppose that P = 100, Y = 1000, and i = 0.10. Find real money demand, nomi

Verizon Corporation has 55% equity and 45% debt (market values) in its capital structure. The pretax cost of debt is 7%, and that of equity 12%. The total value of the company is $

The government of a country has just issued a series of zero-coupon bonds maturing at the end of years 1, 2, 3 and 4. Suppose the spot rates (or continuously compounded yields per