Prepare a cash budget for the month of JULY only from the Beginning Cash Balance to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare a cash budget for the month of JULY only from the Beginning Cash Balance to the Ending Cash Balance. Do not include minimum cash balance in the original cash budget calculations. After you complete the July cash budget, what would you recommend the minimum cash balance be set at? Show ALL CALCULATIONS to get credit. See the budgeted information by month that is at the end of your information data sheet and the following: JULY 1 balance in Cash =$30,000. Collections: 60% collected in the current month and 40% is collected in the next month. Labor payments: 70% of hourly wages paid in the current month and 30% is paid in the next month. Materials payments: 100% is paid in the next month. Overhead payments: 100% is paid in the current month. Do not include minimum cash balance in the initial cash budget. At the end show what you think the minimum cash balance should be based on this month of information. OPERATING ASSETS BUDGET Budgeted operating assets ACTUAL Actual operating assets BUDGETED INCOME STMT FOR 2020 BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET Total 2020 REVENUE 66,921 LABOR HOURS January-20 1,498 February-20 1,747 March-20 April-20 1,747 78,074 1,747 78,074 78,074 May-20 1,747 78,074 June-20 1,997 89,228 July-20 2,496 111,534 August-20 3,744 167,302 September-20 2,995 133,841 October-20 2,496 November-20 1,498 December-20 1,248 111,534 66,921 55,767 24,960 $1.115,344 $860,000 $860,000 DIRECT LABOR SERVICE SELLING/ADMIN MATERIALS OVERHEAD OVERHEAD 18,900 30,671 35,783 22,050 35,783 22,050 35,783 22,050 22,050 25,200 51,118 31,500 76,677 47,250 61,342 37,800 51,118 31,500 30,671 18,900 25,558 15,750 $511,181 $315,000 35,783 40,894 10,500 12,250 12,250 12,250 12,250 2,208 2,524 3,155 4,732 3,785 17,500 3,155 10,500 1,893 8,750 1,576 $175,000 $31.545 14,000 17,500 1,893 2,208 2,208 2,208 26,250 21,000 PROFIT 4,957 5,783 5,783 5,783 5,783 6,610 8,261 12,393 9,914 8,261 4,957 4,133 $82,618 BUDGET Total hourly labor budgeted per hour BUDGET Total budgeted labor dollars ACTUAL Total dollars paid in labor BILLED Total labor dollars billed out BUDGET Budgeted hours work and bill ACTUAL BILLED LABOR: for 12 hourly employees, including benefits BUDGET ACTUAL BUDGET ACTUAL BILLED BUDGET Budget overhead markup % (multiplied by labor+materials) BUDGET Budgeted total overhead costs ACTUAL Actual total overhead costs BILLED Billed overhead to customers BUDGET Budgeted service overhead costs ACTUAL Actual service overhead costs Actual hours worked Billed hours BUDGET BUDGET OVERHEAD AND OVERHEAD MARKUP: NOTE: SERVICE Overhead is a product cost, SELLING & ADMIN Overhead is a period cost. 25% Budgeted selling & admin overhead costs Actual selling & admin overhead costs REVENUE: Budgeted revenue Collected actual revenue Billed revenue PROFIT: Budget profit markup % (multiplied by labor+materials) Budget profit in dollars ACTUAL Actual profit BILLED Billed profit $20.48 $511,181 $559,897 $488,243 24,960 25,210 23,840 $206,545 $231,346 $168,119 $175,000 $186,540 $31,545 $44,806 $1,115,344 $1,048,744 $1,048,744 10.00% 82,618 (63,645) 80,057 FALL 2021 FINAL PROJECT MAINTENANCE DIVISION of CEDAR PROPERTIES MAINTENANCE ACCOUNTING INFORMATION for 2020: Total markup %-Overhead markup % + Profit markup % Billed to customer-[(hours worked on job x billed labor rate/hour)+ (materials used)] x [Total markup Hours worked (billed) on each job=(Time spent at job site+ Time to and from that location) rounded up to 0.25 of an hour (15 minute increments) BILLED The billed labor cost is: BILLED BILLED BILLED BILLED BILLED BILLED BILLED BUDGET ACTUAL BILLED average hourly wage cost paid to maintenance workers x (52 weeks pald/48 weeks worked to account for paid time off) Hourly rate including paid time off Hourly rate including paid time off Average employer hourly wage costs (employer FICA, unemployment taxes, health Insurance) TOTAL BILLED LABOR COST Budget begin, materials Inventory on 1/1/2020 Actual begin, materials Inventory on 1/1/2020 Materials budgeted to purchase HAVE MERENDA MOTE BUDGET ACTUAL BUDGET ACTUAL Total materials billed out BUT $14.00 1.0833 $15.17 MATERIALS: Note: Budgeted beginning and ending materials inventory were assumed to be the same, so materials purchased equals materials used Materials budgeted to purchase $315,000 Materials actually purchased $321,146 Materials billed to customers $312,325 ACTUAL Ending materials inventory on 12/31/2020 before year-end adjustm Budget ending materials inventory count on 12/31/2020 ACTUAL Actual ending materials inventory count on 12/31/2020 BUDGET $15.17 35% 5.31 $20.48 30,000 30,200 315,000 -321,146 HOUR 23,722 30,000 30,200 Prepare a cash budget for the month of JULY only from the Beginning Cash Balance to the Ending Cash Balance. Do not include minimum cash balance in the original cash budget calculations. After you complete the July cash budget, what would you recommend the minimum cash balance be set at? Show ALL CALCULATIONS to get credit. See the budgeted information by month that is at the end of your information data sheet and the following: JULY 1 balance in Cash =$30,000. Collections: 60% collected in the current month and 40% is collected in the next month. Labor payments: 70% of hourly wages paid in the current month and 30% is paid in the next month. Materials payments: 100% is paid in the next month. Overhead payments: 100% is paid in the current month. Do not include minimum cash balance in the initial cash budget. At the end show what you think the minimum cash balance should be based on this month of information. OPERATING ASSETS BUDGET Budgeted operating assets ACTUAL Actual operating assets BUDGETED INCOME STMT FOR 2020 BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET Total 2020 REVENUE 66,921 LABOR HOURS January-20 1,498 February-20 1,747 March-20 April-20 1,747 78,074 1,747 78,074 78,074 May-20 1,747 78,074 June-20 1,997 89,228 July-20 2,496 111,534 August-20 3,744 167,302 September-20 2,995 133,841 October-20 2,496 November-20 1,498 December-20 1,248 111,534 66,921 55,767 24,960 $1.115,344 $860,000 $860,000 DIRECT LABOR SERVICE SELLING/ADMIN MATERIALS OVERHEAD OVERHEAD 18,900 30,671 35,783 22,050 35,783 22,050 35,783 22,050 22,050 25,200 51,118 31,500 76,677 47,250 61,342 37,800 51,118 31,500 30,671 18,900 25,558 15,750 $511,181 $315,000 35,783 40,894 10,500 12,250 12,250 12,250 12,250 2,208 2,524 3,155 4,732 3,785 17,500 3,155 10,500 1,893 8,750 1,576 $175,000 $31.545 14,000 17,500 1,893 2,208 2,208 2,208 26,250 21,000 PROFIT 4,957 5,783 5,783 5,783 5,783 6,610 8,261 12,393 9,914 8,261 4,957 4,133 $82,618 BUDGET Total hourly labor budgeted per hour BUDGET Total budgeted labor dollars ACTUAL Total dollars paid in labor BILLED Total labor dollars billed out BUDGET Budgeted hours work and bill ACTUAL BILLED LABOR: for 12 hourly employees, including benefits BUDGET ACTUAL BUDGET ACTUAL BILLED BUDGET Budget overhead markup % (multiplied by labor+materials) BUDGET Budgeted total overhead costs ACTUAL Actual total overhead costs BILLED Billed overhead to customers BUDGET Budgeted service overhead costs ACTUAL Actual service overhead costs Actual hours worked Billed hours BUDGET BUDGET OVERHEAD AND OVERHEAD MARKUP: NOTE: SERVICE Overhead is a product cost, SELLING & ADMIN Overhead is a period cost. 25% Budgeted selling & admin overhead costs Actual selling & admin overhead costs REVENUE: Budgeted revenue Collected actual revenue Billed revenue PROFIT: Budget profit markup % (multiplied by labor+materials) Budget profit in dollars ACTUAL Actual profit BILLED Billed profit $20.48 $511,181 $559,897 $488,243 24,960 25,210 23,840 $206,545 $231,346 $168,119 $175,000 $186,540 $31,545 $44,806 $1,115,344 $1,048,744 $1,048,744 10.00% 82,618 (63,645) 80,057 FALL 2021 FINAL PROJECT MAINTENANCE DIVISION of CEDAR PROPERTIES MAINTENANCE ACCOUNTING INFORMATION for 2020: Total markup %-Overhead markup % + Profit markup % Billed to customer-[(hours worked on job x billed labor rate/hour)+ (materials used)] x [Total markup Hours worked (billed) on each job=(Time spent at job site+ Time to and from that location) rounded up to 0.25 of an hour (15 minute increments) BILLED The billed labor cost is: BILLED BILLED BILLED BILLED BILLED BILLED BILLED BUDGET ACTUAL BILLED average hourly wage cost paid to maintenance workers x (52 weeks pald/48 weeks worked to account for paid time off) Hourly rate including paid time off Hourly rate including paid time off Average employer hourly wage costs (employer FICA, unemployment taxes, health Insurance) TOTAL BILLED LABOR COST Budget begin, materials Inventory on 1/1/2020 Actual begin, materials Inventory on 1/1/2020 Materials budgeted to purchase HAVE MERENDA MOTE BUDGET ACTUAL BUDGET ACTUAL Total materials billed out BUT $14.00 1.0833 $15.17 MATERIALS: Note: Budgeted beginning and ending materials inventory were assumed to be the same, so materials purchased equals materials used Materials budgeted to purchase $315,000 Materials actually purchased $321,146 Materials billed to customers $312,325 ACTUAL Ending materials inventory on 12/31/2020 before year-end adjustm Budget ending materials inventory count on 12/31/2020 ACTUAL Actual ending materials inventory count on 12/31/2020 BUDGET $15.17 35% 5.31 $20.48 30,000 30,200 315,000 -321,146 HOUR 23,722 30,000 30,200
Expert Answer:
Related Book For
Financial Accounting
ISBN: 978-0078025549
3rd edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
Prepare a cash budget for the Ace Manufacturing Company, indicating receipts and disbursements for May, June, and July. The firm wishes to maintain at all times a minimum cash balance of $20,000....
-
For the month of July Up Payroll Services worked 3,000 hours for Dune Motors, 900 hours for Jake's Charters, and 1,500 hours for Mission Hospital. UP bills clients at $128 an hour; its labor costs...
-
Alberta Limited needs a cash budget for the month of November. The following information is available: a. The cash balance on November 1 is $6,000. b. Sales for October and November are $80,000 and...
-
Discuss the advantages or disadvantages of subsidiary legislations in the Malaysian legal system in dealing with Covid-19 vaccination. Please write down the legal terms for discussion. Please do not...
-
Your manager is trying to determine what forecasting method to use. Based upon the fol-lowing historical data, calculate the following forecast and specify what procedure you would utilize. Month...
-
How do your profits and those of your competitor compare to the case of simultaneous decisions discussed in the text? Would you say that this example of output competition has a first mover advantage...
-
A group of four stars, all the same size, have the four different surface temperatures given below. Which of these stars emits the most red light? A. 3000 K B. 4000 K C. 5000 K D. 6000 K
-
You are the auditor for KPDZ Corporation. You gathered comparative information for inventory and accounts payable and calculated the days purchases in accounts payable. Required: Prepare a list of...
-
What resources will you need to carry out your investigation?
-
1. Discuss the main issues faced by Yalla Momos. 2. Evaluate the current financial performance of Yalla Momos and compare his performance to the industry ratios. 3. Elaborate on the relevant factors...
-
University Canada West wants to invest in a New Post Graduate Program. The Project under consideration costs $27 Million, has a 9 (eight) years life, and has no salvage value. Depreciation is...
-
What kinds of payments does MIT withholding tax apply to and what are the rates of withholding tax? What are the different ways in which superannuation funds may be classified? Explain your answer....
-
Show that an, the number of n digit quarternary sequences (using digits 0, 1, 2, 3) with an even number of zeros and an even number of ones. Use an exponential generating function and solve the...
-
In what ways do supranational organizations such as the United Nations adapt their mandates to address emerging global challenges, and what are the limitations of their effectiveness?
-
Amortization Schedule One of the most common types of personal loans are amortized loans. In order to repay the loan, the borrower will make fixed payments every period. A portion of the payment is...
-
ABC company has successfully adapted licensing as a market entry mode in different countries. What are the advantages of using licensing as entry mode? Analyze the four strategic options available to...
-
A tailor estimates that over the next year 60,000 special zippers will be used in the manufacture of men's jackets. A supplier of closures has quoted a price of $0.60 per closure. The tailor would...
-
What types of inventory issues Starbucks might reflect upon at the end of each year? The mission of Starbucks is to inspire and nurture the human spiritone person, one cup, and one neighborhood at a...
-
Crimson Tide Music Academy offers lessons in playing a wide range of musical instruments. The unadjusted trial balance as of December 31, 2015, appears below. December 31 is the companys fiscal...
-
Below are transactions for Wolverine Company during 2015. a. On December 1, 2015, Wolverine receives $4,400 cash from a company that is renting office space from Wolverine. The payment, representing...
-
Justin Time is confident that firms amortize all intangible assets . Is he right? If amortized, are intangible assets always amortized over their legal life? Explain.
-
An artificial satellite of mass \(m=2.5\) ton is in a circular orbit around the Earth at a distance of \(1600 \mathrm{~km}\) from the surface. Determine the magnitude of the satellite's angular...
-
We normally think that dissipative forces tend to decrease the velocity of an object. This is correct for isolated systems. Consider the case of an artificial satellite of mass \(m\) in a circular...
-
A meteorite is at a distance from the center of the Earth equal to 5 times the Earth's radius \(R_{T}\) with negligible speed and direction of impact toward the ground. Determine the speed with which...
Study smarter with the SolutionInn App