Given the following cost expenditures for a commercial remodeling project, calculate the peak financial requirement (maximum...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the following cost expenditures for a commercial remodeling project, calculate the peak financial requirement (maximum overdraft), the monthly overdrafts, and the financial requirements in each month by completing the table. Assume an 10% markup. Retainage is 7.5% for the first half of the project work schedule. The finance charge is 2% per month. Payments are billed at the end of the month and are received one month later. Draw the overdraft profile, total costs, and payment on the same figure in the space provided. (12 pts) Month 2 3 Direct Cost 9000 15000 12000 6000 Indirect Cost 2000 2000 2000 2000 month 1 (out) (in] 2 (in) (in) 4 (in) (in) direct cost indirect cost total cost markup total billed retainage withheld payment received total cost to date total billed to date total pald to date overdraft interest on overdraft total financed amount Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0 -$10,000 -$20,000 -$30,000 -$40,000 Given the following cost expenditures for a commercial remodeling project, calculate the peak financial requirement (maximum overdraft), the monthly overdrafts, and the financial requirements in each month by completing the table. Assume an 10% markup. Retainage is 7.5% for the first half of the project work schedule. The finance charge is 2% per month. Payments are billed at the end of the month and are received one month later. Draw the overdraft profile, total costs, and payment on the same figure in the space provided. (12 pts) Month 2 3 Direct Cost 9000 15000 12000 6000 Indirect Cost 2000 2000 2000 2000 month 1 (out) (in] 2 (in) (in) 4 (in) (in) direct cost indirect cost total cost markup total billed retainage withheld payment received total cost to date total billed to date total pald to date overdraft interest on overdraft total financed amount Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0 -$10,000 -$20,000 -$30,000 -$40,000
Expert Answer:
Answer rating: 100% (QA)
Month 1 2 3 4 5 Direct Cost 9000 15000 12000 6000 I... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Given the following cost table for an assignment problem, determine the optimal assignment and compute total minimumcost: 6942 C-8144 B-2571 0923 er-1234
-
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to calculate Smithson's fixed costs per month. Round variable cost per unit to two decimal...
-
Given the following cost information, solve for the optimal transportation cost: (Use MODI Method) Plant Cost of transporting 1 load to Plant Project A Project B Project C Project D Project E Project...
-
The Fisher Apparel Company balance sheet for the year ended 2006 is as follows: a. What is Fisher's investment in current assets? b. Determine Fisher's working capital investment. c. Determine...
-
Jack Bibby is a prospector in the Texas Panhandle. He has also been running a side business for the past couple of years. Based on the popularity of shows such as Rattlesnake Nation, there has been a...
-
Assume that an insurance company knows the following probabilities relating to automobile accidents (where the second column refers to the probability that the policyholder has at least one accident...
-
Part One: Economic Order Quantity Compute the economic order quantity for oats based upon the following information related to a manufacturer of granola; round to the nearest whole unit. Assume that...
-
The following events took place for Digital Vibe Manufacturing Company during March, the first month of its operations as a producer of digital video monitors: A. Purchased $168,500 of materials. B....
-
IFRS S1 GENERAL REQUIREMENTS FOR DISCLOSURE OF SUSTAINABILITY-RELATED FINANCIAL INFORMATION An entity shall apply this Standard in preparing and reporting sustainability-related financial disclosures...
-
Presented below is financial information related to the 2020 operations of Sea Legs Cruise Company. Maintenance and repairs expense ............$ 95,000 Utilities expense...
-
If f (x) = 5Cos-r + 13Sin-'r+ 6Te the number of integers in the range of f (x) is. Backspace 7 89 45 6 12 3 Clear All
-
You have to set up an advertising campaign and selected four types of advertising: TV, Radio, Billboards and Newspapers. A summary of information for the formulation of a LP formulation is as...
-
The federal government's General Schedule (GS) is an example of a job classification plan in which pay rates are based, in part, on compensable factors such as knowledge and skills. Jobs are grouped...
-
Write a description for the Training and Development Manager role. You can use the following competencies as references: Identify Needs Develop & Deliver Solutions Strategic Alignment Optimize...
-
Parul is the general manager of an organic coffee company. She wants to give one of her employees an "Employee of the Year" award. Which individual should she choose if she is looking for an employee...
-
The revenues and expenses of Zenith Travel Service for the year ended August 31, 20Y4, follow: Fees earned Office expense Miscellaneous expense Wages expense $989,435 227,570 19,790 474,930 Prepare...
-
Sandra is a Portfolio manager with Money Friends Sana Plc. She is evaluating the expected performance of two sub-portfolios, Wonder and Treasure for possible inclusion in a rebalanced portfolio. She...
-
From a medical tourist perspective, compare Shouldice with the traditional hospital in terms of the key factors of competition. Using Table 15-3, why would Shouldice attract patients from outside the...
-
The Grady Tire Company recaps tires. The weekly fixed cost is $2,500, and the variable cost per tire is $9. Price is related to demand, according to the following linear equation: v = 200 - 4.75p...
-
The Miramar Company in Problem 18 is considering contracting with a market research firm to do a survey to determine future market conditions. The results of the survey will indicate either positive...
-
Reconstruct the example problem at the end of this chapter as an AOA network. Assume that the most likely times (m) are the normal activity times and that the optimistic times (a) are the activity...
-
Which of the following statements is true? a. Encrypting data is sufficient to protect confidentiality and privacy. b. Cookies are text files that only store information and cannot do anything. c. A...
-
Which of the following is designed to identify entry of a nonexistent customer account number? a. sequence check c. completeness check b. field check d. validity check
-
A batch total that is calculated by summing the part numbers sold in a batch of 50 sales invoices is called a a. financial total c. record count b. hash total d. part count
Study smarter with the SolutionInn App