Create the following budgets for each quarter in the year with the data provided below. Each...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create the following budgets for each quarter in the year with the data provided below. Each budget will show results for each quarter and a total for the year. 1. Sales budget 2. Cash collections budget 3. Cash budget Data 1) The budgeted unit sales are 500 units, 700 units, 800 units, and 1,000 units for quarters 1-4, respectively. The budgeted selling price for the year is $50 per unit. 2) All sales are on credit. 50% percent of all credit sales are collected in the quarter of the sale, 35% are collected in the next quarter, and the remainder is collected in the quarter after. The following data is provided to complete the cash collections budget: a. Q1 cash collection from prior year Q4 sales: $9,000 b. Q1 cash collection from prior year Q3 sales: $2,000 c. Q2 cash collection from prior year Q4 sales: $1,000 3) The company plans to maintain a minimum cash balance at the end of each quarter of $60,000. If the cash balance is below $60,000, the company will borrow money from the bank to arrive at a $60,000 balance. All borrowings take place on the first day of the quarter and have a 12-month maturity, an interest rate of 2.5% per quarter, and interest paid quarterly. The following data is provided to complete the cash budget: a. Beginning cash balance: $70,000 b. Q1 cash disbursement: $26,000 c. Q2 cash disbursement: $41,250 d. Q3 cash disbursement: $34,000 e. Q4 cash disbursement: $38,000 Create the following budgets for each quarter in the year with the data provided below. Each budget will show results for each quarter and a total for the year. 1. Sales budget 2. Cash collections budget 3. Cash budget Data 1) The budgeted unit sales are 500 units, 700 units, 800 units, and 1,000 units for quarters 1-4, respectively. The budgeted selling price for the year is $50 per unit. 2) All sales are on credit. 50% percent of all credit sales are collected in the quarter of the sale, 35% are collected in the next quarter, and the remainder is collected in the quarter after. The following data is provided to complete the cash collections budget: a. Q1 cash collection from prior year Q4 sales: $9,000 b. Q1 cash collection from prior year Q3 sales: $2,000 c. Q2 cash collection from prior year Q4 sales: $1,000 3) The company plans to maintain a minimum cash balance at the end of each quarter of $60,000. If the cash balance is below $60,000, the company will borrow money from the bank to arrive at a $60,000 balance. All borrowings take place on the first day of the quarter and have a 12-month maturity, an interest rate of 2.5% per quarter, and interest paid quarterly. The following data is provided to complete the cash budget: a. Beginning cash balance: $70,000 b. Q1 cash disbursement: $26,000 c. Q2 cash disbursement: $41,250 d. Q3 cash disbursement: $34,000 e. Q4 cash disbursement: $38,000
Expert Answer:
Answer rating: 100% (QA)
Sales Budget Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total a Sales Unit 500 700 800 1000 3000 b Pric... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-1259024900
9th canadian edition
Authors: Ray Garrison, Theresa Libby, Alan Webb
Posted Date:
Students also viewed these accounting questions
-
With the data provided below from the Taxpayer, please perform the computations of the income tax return for the year 2019 required in the fiscal year. Taxpayer data: Resident taxpayer of PR all year...
-
10. Prepare the following budgets for the month of December 2013. (a) Sales. (b) Production. (c) Direct materials. (d) Direct labor. (e) Selling and administrative expenses. (f) Cash. (g) Budgeted...
-
1.) On January 1, 2014, Jack Company issues $3,744,000, 6%, 10-year bonds for cash of $3,013,464 when the market rate of interest is 9%. The bonds pay interest semi-annually on June 30 and December...
-
The banker's acceptance and the commercial letter of credit involve four principal parties. Which of the following is not one of those parties? The importer The exporter O The receiving country's...
-
Mr. Harvey Robinson donated $2,000,000 to the University of Aggiemania with the stipulation that earnings of the first 10 years be used to endow professorships in each of the universitys colleges. At...
-
In December 2018, Apple had cash of $86.43 billion, current assets of $140.83 billion, and current liabilities of $108.28 billion. It also had inventories of $4.99 billion. a. What was Apples current...
-
Why do auditors not usually rely on substantive tests alone when auditing accounts payable that result from credit purchase transactions?
-
Clean Corporation manufactures liquid window cleaner. The following information concerns its work in process: Beginning inventory, 8,000 partially complete gallons. Transferred out, 42,000 gallons....
-
What is the most efficient speed to drive? Assume that a modern car has a 2 m2 frontal area and a drag coefficient of 0.25. Assume that there are two sources of energy dissipated during driving: a...
-
The U.S. Department of Commerce publishes a series of census documents referred to as Current Industrial Reports. Included in these documents are the manufacturers shipments, Inventories, and orders...
-
A beverage company wants their new product to come in 222 ml cans, and the designer wants the can to use the least amount of material possible.Find the height and radius of the cylinder with a volume...
-
The Tornado Integrated Project Team (Tornado IPT) is part of the UK Ministry of Defence's (MoD's) Defence Equipment and Support (DE&S) organisation. It is responsible for the provision of logistical...
-
Getting the HUMS project off the ground Health and Usage Monitoring Systems (HUMS) is a technology that uses vibration-based drive-train monitoring to accurately determine a helicopter's mechanical...
-
Solve the currents flowing through the resistors. Give the answers to one decimal place. R = 159, R = 10, R3 = 309, E = 60V and J = 3A I A 12 13 A A
-
9. Three point-like charges are placed at the following points on the x-y system coordinates (q1 is fixed at x = -1.00 cm, 92 is fixed at y = +2.00 cm, and q3 is fixed at x = +3.00 cm. Find the...
-
You have learned the key characteristics of projects in Topic 1 of this unit. Part A requires you to apply this knowledge and any further research to a real project. A project has numerous...
-
Review this spreadsheet and answer the following questions: a.The portfolio beta calculated is 0.61. Explain how the calculated beta would change if your company were dropped from the portfolio and...
-
Following is the current balance sheet for a local partnership of doctors: The following questions represent independent situations: a. E is going to invest enough money in this partnership to...
-
Purchasing a large oven and related equipment for mixing and baking crazy bread is being considered by Perottis Pizza. The oven and equipment would cost $120,000 delivered and installed. It would be...
-
Roll Board Inc. manufactures several models of high-quality skateboards. The companys ABC system has four activity cost pools, which are listed below along with their activity measures and activity...
-
Scotia Family Health Team is investigating purchasing an ultrasound machine for use in its patient clinic. The machine would cost $97,900, including invoice cost, freight, and the training of...
-
A system has the differential equations \(\left[\begin{array}{lll}5 & 0 & 0 \\ 0 & 3 & 0 \\ 0 & 0 & 2\end{array} ight]\left[\begin{array}{c}\ddot{x}_{1} \\ \ddot{x}_{2} \\ \ddot{x}_{3}\end{array}...
-
Lagranges equations are used to derive the differential equations for a three degree-of-freedom system resulting in \(\left[\begin{array}{lll}m_{11} & m_{12} & m_{13} \\ m_{21} & m_{22} & m_{23} \\...
-
The following data relate to the manufacturing activities of MilTech company during November: 1. Sales $400,000 2. Purchases $60,700 3. Expenses include: Light and power for manufacturing: $2,700 ...
Study smarter with the SolutionInn App