Excellent Corporation has the following budgeted sales for the next six-month period: Unit Sales 90,000 120,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excellent Corporation has the following budgeted sales for the next six-month period: Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 Month June July August September October November Each unit is expected to sell for $125. Sixty percent of sales are on credit, forty percent are cash sales. Of the credit sales, 40% is collected in the month of sale, 60% in the month following. There are no bad debts. The June Accounts Receivable balance will be collected in July. There were 50,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 30% of the unit sales for the next month. Seven kilograms of materials are required for each unit produced. Each kilogram of material costs $10. Inventory levels for materials are equal to 30% of the production needs for the next month. Materials inventory on June 1 was 15,000 kilograms. < Materials are purchased in the month before production and are paid 50% in the month of purchase and 50% in the month following. The June Accounts Payable balance will be collected in July. Required: (a) Prepare production budgets in units for July and August. (4 marks) (b) Prepare a materials purchases budget in kilograms for July and August. (4 marks)< (c) Prepare the Cash Collections from Sales for July and August. (4 marks)< (d) Prepare the Cash Disbursements for Materials for July and August. (3 marks)< Excellent Corporation has the following budgeted sales for the next six-month period: Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 Month June July August September October November Each unit is expected to sell for $125. Sixty percent of sales are on credit, forty percent are cash sales. Of the credit sales, 40% is collected in the month of sale, 60% in the month following. There are no bad debts. The June Accounts Receivable balance will be collected in July. There were 50,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 30% of the unit sales for the next month. Seven kilograms of materials are required for each unit produced. Each kilogram of material costs $10. Inventory levels for materials are equal to 30% of the production needs for the next month. Materials inventory on June 1 was 15,000 kilograms. < Materials are purchased in the month before production and are paid 50% in the month of purchase and 50% in the month following. The June Accounts Payable balance will be collected in July. Required: (a) Prepare production budgets in units for July and August. (4 marks) (b) Prepare a materials purchases budget in kilograms for July and August. (4 marks)< (c) Prepare the Cash Collections from Sales for July and August. (4 marks)< (d) Prepare the Cash Disbursements for Materials for July and August. (3 marks)<
Expert Answer:
Related Book For
Cornerstones of Managerial Accounting
ISBN: 978-0176530884
2nd Canadian edition
Authors: Maryanne M. Mowen, Don Hanson, Dan L. Heitger, David McConomy, Jeffrey Pittman
Posted Date:
Students also viewed these accounting questions
-
Patel Instruments Company has the following sales budget for the first three months of the current year: Month Sales Revenue January $900,000 February 225,000 March 660,000 Historically, the...
-
Manasee Atre is an award-winning innovator who makes educational toys for preschool children. Manasees company, which she whimsically named Pumpkin Patch, makes plastic pieces that can be assembled...
-
You think XYZ stock has potential for an upward move in price. You have no position whatsoever in the stock now. You would like to take the opportunity of any up movement in price but want to...
-
Bob Bristol just called to congratulate you on your excellent work on the various assignments at CII.He now wants you to do some capacity analysis for Meghan Willoughby, the Chief Purser. Meghan is...
-
Show that the curve y = x tan1x has two slant asymptotes: y = x + /2 and y = x /2. Use this fact to help sketch the curve.
-
The secondary voltage of an ignition transformer in a furnace is 10.0 kV. When the primary operates at an rms voltage of 120 V, the primary impedance is 24.0 and the transformer is 90.0% efficient....
-
What advantages are there to using social media sites for informal discovery? How may the information you find help in settling a civil lawsuit?
-
Justification/Recommendation Report: Improving Greenhouse Markets Service You are a recently hired manager for Greenhouse Market, a highend fast-food restaurant that has been in business for three...
-
: You are going to take over a Family owned business that has been in existence for 4 generations. However, you realize that you have adopted a hierarchical top down decision making style from your...
-
Many processor architectures have a load with post-increment instIt is not possible to implement this instruction without either modifying the register file (adding another write port) or making the...
-
Are there new services or policies you can think of, as an expert in brain disorders/ mental health, that may help to ensure that the human rights of people with disabilities are protected in cases...
-
Mr. Jason Prasad is the owner and Manager ofJason's fast food and takeaways, a restaurant business situated at Lot 1, Queens Road Martintar, Nadi. As the family business grew Mr. Prasad hired Ms....
-
Can answer each question below. It is due tomorrow at midnight . Activity 1: Data from Law Enforcement Agencies Answer each of the following questions: Define the terms UCR, NIBRS, SHR and NCVS ....
-
Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between each pair of cities in the accompanying data, which shows the solution to an optimization model that finds...
-
If your household/family is spending 15% of your income( list ALL incomes) on food each year, what is the highest amount of money you could spend on food per week? Based on your own values, do you...
-
How do diasporic communities negotiate identity formation and belonging across transnational spaces, and how does this impact cultural hybridity and diasporic consciousness ?
-
An electric motor drive an exhaust fan. Following data are providing: Motor Pulley Fan Pulley 1800 3.78 0.28 225 Diameter (mm) Angle of contact (rad) Coefficient of friction Speed (rpm) Power...
-
State whether each statement is true or false. If false, give a reason. {purple, green, yellow} = {green, pink, yellow}
-
Rajvir, an owner of a quickly growing three-year-old small-sized manufacturing business employing 43 staff, storms into her offsite accountant's office. Rajvir: That's it! I've had it with this...
-
Larco Ltd. is considering investing in a new machine and has reduced the options to one of two types of machinery. Both machines will have a five-year life and have zero salvage value at the end of...
-
The Pineapple Pen Company is divided into two operating divisions: pens and pencils. The company allocates the cost of the cafeteria and the maintenance department to each operating division using...
-
For flow over a smooth plate, what approximately is the maximum length of the laminar boundary layer if \(V_{o}=9.0 \mathrm{~m} / \mathrm{s}\) in the irrotational uniform flow and the fluid is air?...
-
A student is to design an experiment involving dragging a sphere through a tank of fluid to illustrate (a) "creeping flow" \(\left(R e_{D} <1 ight)\) (b) flow for which the boundary layer becomes...
-
We have seen many examples in Chapter 7 of replacing working fluids in order to more easily achieve similitude between models and prototypes. Describe the effects of testing an air compressor using...
Study smarter with the SolutionInn App