Can you help make a cash payments budget and combined cash budget for each quarter and for
Fantastic news! We've Found the answer you've been seeking!
Question:
Can you help make a cash payments budget and combined cash budget for each quarter and for the year in total. List clearly each type of cash payments (for shirts purchases, labor, overhead, and S&A, and so on). Tip: Depreciation does not require a cash payment.
Transcribed Image Text:
Revenue Selling Price Estimated Number of shirts Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 1 Schedule of Collections Cash Collected in Quarter Cash Collected following Quarter Cash Collected in second quarter following Cost Assumptions Purchasing Cost per sweatshirt Desired ending inventory Scheduled payments To be paid in the quarter of purchase To be paid in following quarter Direct labor Costs Hourly wage rate for workers Silk-screening labor hours per shirt 26.5 4700 6800 9100 7600 8200 50% 35% 15% 13.1 25% 40% 60% 14.2 0.1 Costs Sales Compensation Monthly Salary Commision Percentage Designer Costs Monthly Per Shirt Building Costs Rent of building Percent of buliding for silk screening Percent of building for sales and admin Other Cost of ink per shirt advertising cost property taxes and machinery insurance furniture and register tax utilities per shirt maintenance per shirt utilities monthly fixed cost maintenance monthly fixed cost Other Items total equipment cost to be paid in quarter 1 and 2 laon amount interest rate on loan 1260 8.60% $ 680.00 0.27 1500 75% 25% 0.84 108 per week 2640 annually but $ 420.00 paid quarterly 0.10 per shirt 0.08 per shirt 955 1524 1826 40000 8% Revenue Selling Price Estimated Number of shirts Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 1 Schedule of Collections Cash Collected in Quarter Cash Collected following Quarter Cash Collected in second quarter following Cost Assumptions Purchasing Cost per sweatshirt Desired ending inventory Scheduled payments To be paid in the quarter of purchase To be paid in following quarter Direct labor Costs Hourly wage rate for workers Silk-screening labor hours per shirt 26.5 4700 6800 9100 7600 8200 50% 35% 15% 13.1 25% 40% 60% 14.2 0.1 Costs Sales Compensation Monthly Salary Commision Percentage Designer Costs Monthly Per Shirt Building Costs Rent of building Percent of buliding for silk screening Percent of building for sales and admin Other Cost of ink per shirt advertising cost property taxes and machinery insurance furniture and register tax utilities per shirt maintenance per shirt utilities monthly fixed cost maintenance monthly fixed cost Other Items total equipment cost to be paid in quarter 1 and 2 laon amount interest rate on loan 1260 8.60% $ 680.00 0.27 1500 75% 25% 0.84 108 per week 2640 annually but $ 420.00 paid quarterly 0.10 per shirt 0.08 per shirt 955 1524 1826 40000 8%
Expert Answer:
Answer rating: 100% (QA)
Here is the cash payments budget and combined cash budget for Bloomfield Apparel for each quarter of ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Presidio Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Presidio Manufacturing's operations: Current assets as of December 31...
-
Describe the graphs of the equation. x 2 + y 2 3
-
During 2012, Spelling Inc. purchased the following trading securities: Security .................................................. Cost ............... Fair Value, Dec. 31, 2012 Bizarre Corp. common...
-
vit 4. Two waves are superposed in a medium. If the displacement from one wave is 7 units up, while the resultant displacement is 3 units down, then what is the displacement of the other wave?
-
Helgeson Enterprises, Corp., completed the following selected transactions and prepared these adjusting entries during January: 2. Compute January net income or net loss under the accrual basis of...
-
At the beginning of September, Alexandria Perez started Perez Investment Services, a firm that offers advice about investing and managing money. On September 30, the accounting records of the...
-
Read any article from https://www.thefashionlaw.com/Links to an external site. , suggested further reading or any relevant current article and answer the following questions: What is the title of the...
-
Which of the following is a positive reason for learning chemistry? (a) Chemistry is relevant to daily life (b) Chemistry offers career opportunities (c) Chemistry studies interesting topics (d)...
-
Match the descriptions below with the correct answer, using the letter codes shown in the table below. (8 points) A. Realizable value B. Percentage of receivables method C. 3/10, n/60 D. Bad debt...
-
In the past a skilled assistant would proofread her bosss documents and correct any errors he made. Revise the following sentences to reduce bias (e.g., gender, racial, ethnic, age, and disability).
-
GlaxoSmithKline is one of the largest pharmaceutical firms in the world, and over an extended period of time in the recent past, it consistently earned higher ROEs than the pharmaceutical industry as...
-
What approaches would you use to estimate the value of brands? What assumptions underlie these approaches? As a financial analyst, what would you use to assess whether the brand value of 8.3 billion...
-
Some argue that (1) because estimating the value of contingent claims (such as executive stock options) is surrounded with uncertainty and (2) the claims do not represent a cash outlay, the value of...
-
If you receive two job offers at once, you can probably (get, land, negotiate) a better deal. From the choices in parentheses, select the most precise, vigorous words.
-
If the economy's real GDP doubles in 18 years: A. not say anything about the average annual rate of growth. B. conclude that its average annual rate of growth is about 5.5 percent. C. conclude that...
-
Phosgene, COCl2, is a toxic gas used in the manufacture of urethane plastics. The gas dissociates at high temperature. At 400oC, the equilibrium constant Kc is 8.05 104. Find the percentage of...
-
Refer to the supermarket in S12- 13. What is the approximate internal rate of return (IRR) of the kiosk investment? In S12- 13 The local supermarket is considering investing in self- checkout kiosks...
-
Thornton Corporation uses the indirect method to prepare its statement of cash flows. Data related to cash activities for last year is as follows: Net...
-
Monette Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: a. Cash...
-
The beam is constructed from two boards fastened together at the top and bottom with three rows of nails spaced every \(8 \mathrm{in}\). If an internal shear force of \(V=800 \mathrm{lb}\) is applied...
-
The beam is constructed from two boards fastened together at the top and bottom with three rows of nails spaced every 8 in. If each nail can support a \(300-\) lb shear force, determine the maximum...
-
The double-web girder is constructed from two plywood sheets that are secured to wood members at its top and bottom. If each fastener can support \(600 \mathrm{lb}\) in single shear, determine the...
Study smarter with the SolutionInn App