Jonas Consulting enters into a contract to provide cost management consulting services over a one-year period for $10,000 per month on January 1. At the end of the contract, Jonas will either give the customer a $24,000 refund or be entitled to an additional $24,000, depending on the level of cost savings. The company believes there is an 80% chance that it will be entitled to an additional $24,000 and a 20% chance it will give a refund of $24,000. In addition, Jonas believes it is probable that a significant reversal of any previously recognized revenue will not occur. The contract performance is determined to be satisfied over time.
Part A: Prepare the journal entry on January 31 to record the first month of the contract using the most likely amount approach.
Part B: Determine the monthly transaction price that Jonas should use for recording the contract using the most likely amount approach.
In: Accounting
E) Aaron, Deanne, and Keon formed the Blue Bell General Partnership at the beginning of the current year. Aaron and Deanne each contributed $110,000 and Keon transferred an acre of undeveloped land to the partnership. The land had a tax basis of $70,000 and was appraised at $180,000. The land was also encumbered with a $70,000 nonrecourse mortgage for which no one was personally liable. All three partners agreed to split profits and losses equally. At the end of the first year Blue Bell made a $7,000 principal payment on the mortgage. For the first year of operations, the partnership records disclosed the following information:Sales revenue $470,000Cost of goods sold $410,000Operating expenses $70,000Long-term capital gains $2,400§1231 gains $900Charitable contributions $300Municipal bond interest $300Salary paid as a guaranteed payment to Deanne (not included inexpenses)
a.Compute the adjusted basis of each partner’s interest in the partnership immediately after the formation of the partnership.b.List the separate items of partnership income, gains, losses, and deductions that the partners must show on their individual income tax returns that include the results of the partnership’s first year of REVIEW QUESTIONSoperations.c.What are the partners’ adjusted bases in their partnership interests at the end of the first year of operations
In: Accounting
(1) Playing with data: Download quarterly, seasonally adjusted data on US real GDP, personal consumption expenditures, and gross private domestic investment for the period 1947q1 - 2010q2. You can download these series from the Bureau of Economic Analysis (BEA) or the St. Louis Fed FRED database.
(a) Take the natural logarithm of each series (ì=ln(series)î in Excel) and plot each against time. Which series appears to move around the most? Which series appears to move around the least?
(b) The growth rate of a random variable, x, between dates t 1 and t is deÖned as: g x t = xt xt1 xt1 Calculate the growth rate of each of the three series (using the raw series, not the logged series) and write down the average growth rate of each series over the entire post-war sample period. Are the average growth rates of each series approximately the same?
(c) We argued in class that the Örst di§erence of the log is approximately equal to the growth rate: g x t ln xt ln xt1 Compute the approximate growth rate of each series this way. Comment on the quality of the approximation.
(d) The standard deviation of a series of random variables is a measure of how much the variable jumps around about its m (Excel command ì=stdev(series)î). Take the time series standard deviations of the growth rates of the three series mentioned above and rank them in terms of magnitude.
(e) The National Bureau of Economic Research (NBER) declares business cycle peaks and troughs (i.e. recessions and expansions) through a subjective assessment of overall economic conditions. A popular deÖnition of a recession ñnot the one used by the NBER ñis a period of time in which real GDP declines for at least two consecutive quarters. Use this consecutive quarter decline deÖnition to come up with your own recession dates for the entire post-war period. Compare the dates to those given by the NBER (just google ìNBER recession datesîto Önd those dates).
(f) The most recent recession is dated by the NBER to have begun in the fourth quarter of 2007. Compute the average growth rate of real GDP for the period 2003q1 - 2007q3. Compute a counterfactual time path of real GDP if it had grown at that rate over the period 2007q4-2010q2. Use that counterfactual simulation to speculate (intelligently) on the welfare cost of business cycles.
In: Economics
Allen Products LP, wants to do a scenario analysis for the coming year. The pessimistic prediction for sales is $ 900,000; the most likely amount of sales is $ 1,118,000; and the optimistic prediction is $ 1,288,000. Allen's income statement for the most recent year is shown here
Allen Products, Inc. Income Statement for
the Year Ended December 31, 2019
Sales revenue $937,400
Less: cost of good sold 436,828
Gross profits $500,572
Less: operating expenses 245,599
Operating profits $254,973
Less: interest expense 30,934
Net profit before taxes $224,039
Less: taxes (rate 25%) 56,010
Net profits after taxes $168,029
a. Use the percent-of-sales method, the income statement for December 31,2019, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year.
b. Explain how this method could result in overstatement of profits for the pessimistic case and understatement of profits for the most likely and optimistic cases.
c. Restate the pro forma income statements prepared in part a. to incorporate the following assumptions about the costs:
$252,497 of the cost of goods sold is fixed; the rest is variable. $193,516 of the operating expenses is fixed; the rest is variable. All the interest expense is fixed.
d. Compare your findings in part c. to your findings in part a. Do your observations confirm your explanation in part b?
Use the percent-of-sales method, the income statement for December 31, 2019, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year.
Complete the pro forma income statement for the year ending December 31, 2020 that is shown below (pessimistic scenario): (Round the percentage of sales to one decimal place and the pro forma income statement accounts to the nearest dollar.)
In: Finance
Today you decide to invest $10,000 in an investment account that earns 2% every quarter. Five years from today $ ____________ will have accumulated in the account. (Round to the nearest penny.)
In: Finance
In: Statistics and Probability
At what substrate concentration would an enzyme with Km of 5mM operate at one-quarter its maximum rate? Give your answer in units of mM to 1 decimal place.
In: Biology
Performance Lawn Equipment (PLE)
PLE, headquartered in St. Louis, Missouri, is a privately-owned designer and producer of traditional lawn mowers used by homeowners. Annual sales are approximately $180 million. Both end users and institutions (organizations) are important customers for PLE. This case is ONLY about organizations (such as retail outlets) that buy from PLE. There are two type of organizations that are PLE customers: (1) dealerships or retail stores that in-turn sell to end-customers, and (2) organizations that buy products to use in their operations (such as golf courses or professional lawn care businesses). A purchasing manager in such organizations makes the decisions about which brand of lawn mowers to buy and how many to buy.
Elizabeth Burke has recently joined the PLE management team to oversee production operations. She has asked you to analyze results of a survey of purchasing managers in PLE’s institutional customers.
The worksheet Purchasing Survey in the Performance Lawn Care database provides data obtained from a survey of purchasing managers of institutional customers. Respondents rated PLE on the following seven attributes:
Delivery speed-the amount of time it takes to deliver the product once an order is confirmed
Price level-the perceived level of price charged by PLE
Price flexibility-the perceived willingness of PLE representatives to negotiate price on all types of purchases
Manufacturing image-the overall image of the manufacturer
Overall service-the overall level of Service necessary for maintaining a satisfactory relationship between PLE and the purchaser
Sales force image—the overall image of the PLE’s Sales force
Product quality-perceived level of quality
Responses to these Seven Variables were obtained using a graphic rating Scale, where a 10-centimeter line was drawn between endpoints labeled "poor and 'excellent." Respondents indicated their perceptions using a mark on the line, which was measured from the left endpoint. The result was a scale from 0 to 10 rounded to One decimal place.
Two measures were obtained that reflected the outcomes of the respondent's purchase relationships with PLE:
Usage level-how much of the firm's total product is purchased from PLE, measured on a 100-point Scale, ranging from 0% to 100%
Satisfaction level-how satisfied the purchaser is with past purchases from PLE, measured on the same graphic rating scale as perceptions 1 through 7
The data also include four characteristics of the responding firms:
Size of firm-size relative to others in this market (O = Small; 1 = large)
Purchasing structure-the purchasing method used in a particular company (1 = centralized procurement, 0 = decentralized procurement)
Industry-the industry classification of the purchaser l = retail (stores that resell to end consumers such as Home Depot), 0 = private (nonresale, Such as a profession lawn care business)
Buying type-a Variable that has three categories (1 = new purchase, 2 = modified rebuy, 3 = Straight rebuy)
Elizabeth Burke would like to understand what she learned from this data.
Cluster Analysis:
Apply cluster analysis to analyze the data to create a segmentation of institutional customers. For example, can PLE segment customers into groups with similar perceptions about the company? Do not use “Usage level” or “Satisfaction level” in making the clusters. Check to see if the clusters differ on usage level and satisfaction or not. Which clusters have high usage and satisfaction and which ones do not? Suggest actions management can take to increase usage and satisfaction for the different clusters.
Regression Analysis:
Can regression models provide insight about the drivers of satisfaction and usage level? What are the most important variables that need to be influenced to increase satisfaction and usage level? Suggest ways management can do so.
Summarize your results in a report to Ms. Burke.
| Purchasing Survey | ||||||||||||
| Delivery speed | Price level | Price flexibility | Manufacturing image | Overall service | Salesforce image | Product quality | Usage Level | Satisfaction Level | Size of firm | Purchasing Structure | Industry | Buying Type |
| 4.1 | 0.6 | 6.9 | 4.7 | 2.4 | 2.3 | 5.2 | 32 | 4.2 | 0 | 0 | 1 | 1 |
| 1.8 | 3 | 6.3 | 6.6 | 2.5 | 4 | 8.4 | 43 | 4.3 | 1 | 1 | 0 | 1 |
| 3.4 | 5.2 | 5.7 | 6 | 4.3 | 2.7 | 8.2 | 48 | 5.2 | 1 | 1 | 1 | 2 |
| 2.7 | 1 | 7.1 | 5.9 | 1.8 | 2.3 | 7.8 | 32 | 3.9 | 1 | 1 | 1 | 1 |
| 6 | 0.9 | 9.6 | 7.8 | 3.4 | 4.6 | 4.5 | 58 | 6.8 | 0 | 0 | 1 | 3 |
| 1.9 | 3.3 | 7.9 | 4.8 | 2.6 | 1.9 | 9.7 | 45 | 4.4 | 1 | 1 | 1 | 2 |
| 4.6 | 2.4 | 9.5 | 6.6 | 3.5 | 4.5 | 7.6 | 46 | 5.8 | 0 | 0 | 1 | 1 |
| 1.3 | 4.2 | 6.2 | 5.1 | 2.8 | 2.2 | 6.9 | 44 | 4.3 | 1 | 1 | 0 | 2 |
| 5.5 | 1.6 | 9.4 | 4.7 | 3.5 | 3 | 7.6 | 63 | 5.4 | 0 | 0 | 1 | 3 |
| 4 | 3.5 | 6.5 | 6 | 3.7 | 3.2 | 8.7 | 54 | 5.4 | 1 | 1 | 0 | 2 |
| 2.4 | 1.6 | 8.8 | 4.8 | 2 | 2.8 | 5.8 | 32 | 4.3 | 0 | 0 | 0 | 1 |
| 3.9 | 2.2 | 9.1 | 4.6 | 3 | 2.5 | 8.3 | 47 | 5 | 0 | 0 | 1 | 2 |
| 2.8 | 1.4 | 8.1 | 3.8 | 2.1 | 1.4 | 6.6 | 39 | 4.4 | 1 | 1 | 0 | 1 |
| 3.7 | 1.5 | 8.6 | 5.7 | 2.7 | 3.7 | 6.7 | 38 | 5 | 0 | 0 | 1 | 1 |
| 4.7 | 1.3 | 9.9 | 6.7 | 3 | 2.6 | 6.8 | 54 | 5.9 | 0 | 0 | 0 | 3 |
| 3.4 | 2 | 9.7 | 4.7 | 2.7 | 1.7 | 4.8 | 49 | 4.7 | 0 | 0 | 0 | 3 |
| 3.2 | 4.1 | 5.7 | 5.1 | 3.6 | 2.9 | 6.2 | 38 | 4.4 | 0 | 1 | 1 | 2 |
| 4.9 | 1.8 | 7.7 | 4.3 | 3.4 | 1.5 | 5.9 | 40 | 5.6 | 0 | 0 | 0 | 2 |
| 5.3 | 1.4 | 9.7 | 6.1 | 3.3 | 3.9 | 6.8 | 54 | 5.9 | 0 | 0 | 1 | 3 |
| 4.7 | 1.3 | 9.9 | 6.7 | 3 | 2.6 | 6.8 | 55 | 6 | 0 | 0 | 0 | 3 |
| 3.3 | 0.9 | 8.6 | 4 | 2.1 | 1.8 | 6.3 | 41 | 4.5 | 0 | 0 | 0 | 2 |
| 3.4 | 0.4 | 8.3 | 2.5 | 1.2 | 1.7 | 5.2 | 35 | 3.3 | 0 | 0 | 0 | 1 |
| 3 | 4 | 9.1 | 7.1 | 3.5 | 3.4 | 8.4 | 55 | 5.2 | 0 | 1 | 0 | 3 |
| 2.4 | 1.5 | 6.7 | 4.8 | 1.9 | 2.5 | 7.2 | 36 | 3.7 | 1 | 1 | 0 | 1 |
| 5.1 | 1.4 | 8.7 | 4.8 | 3.3 | 2.6 | 3.8 | 49 | 4.9 | 0 | 0 | 0 | 2 |
| 4.6 | 2.1 | 7.9 | 5.8 | 3.4 | 2.8 | 4.7 | 49 | 5.9 | 0 | 0 | 1 | 3 |
| 2.4 | 1.5 | 6.6 | 4.8 | 1.9 | 2.5 | 7.2 | 36 | 3.7 | 1 | 1 | 0 | 1 |
| 5.2 | 1.3 | 9.7 | 6.1 | 3.2 | 3.9 | 6.7 | 54 | 5.8 | 0 | 0 | 1 | 3 |
| 3.5 | 2.8 | 9.9 | 3.5 | 3.1 | 1.7 | 5.4 | 49 | 5.4 | 0 | 0 | 1 | 3 |
| 4.1 | 3.7 | 5.9 | 5.5 | 3.9 | 3 | 8.4 | 46 | 5.1 | 1 | 1 | 0 | 2 |
| 3 | 3.2 | 6 | 5.3 | 3.1 | 3 | 8 | 43 | 3.3 | 1 | 1 | 0 | 1 |
| 2.8 | 3.8 | 8.9 | 6.9 | 3.3 | 3.2 | 8.2 | 53 | 5 | 0 | 1 | 0 | 3 |
| 5.2 | 2 | 9.3 | 5.9 | 3.7 | 2.4 | 4.6 | 60 | 6.1 | 0 | 0 | 0 | 3 |
| 3.4 | 3.7 | 6.4 | 5.7 | 3.5 | 3.4 | 8.4 | 47 | 3.8 | 1 | 1 | 0 | 1 |
| 2.4 | 1 | 7.7 | 3.4 | 1.7 | 1.1 | 6.2 | 35 | 4.1 | 1 | 1 | 0 | 1 |
| 1.8 | 3.3 | 7.5 | 4.5 | 2.5 | 2.4 | 7.6 | 39 | 3.6 | 1 | 1 | 1 | 1 |
| 3.6 | 4 | 5.8 | 5.8 | 3.7 | 2.5 | 9.3 | 44 | 4.8 | 1 | 1 | 1 | 2 |
| 4 | 0.9 | 9.1 | 5.4 | 2.4 | 2.6 | 7.3 | 46 | 5.1 | 0 | 0 | 1 | 3 |
| 0 | 2.1 | 6.9 | 5.4 | 1.1 | 2.6 | 8.9 | 29 | 3.9 | 1 | 1 | 1 | 1 |
| 2.4 | 2 | 6.4 | 4.5 | 2.1 | 2.2 | 8.8 | 28 | 3.3 | 1 | 1 | 1 | 1 |
| 1.9 | 3.4 | 7.6 | 4.6 | 2.6 | 2.5 | 7.7 | 40 | 3.7 | 1 | 1 | 1 | 1 |
| 5.9 | 0.9 | 9.6 | 7.8 | 3.4 | 4.6 | 4.5 | 58 | 6.7 | 0 | 0 | 1 | 3 |
| 4.9 | 2.3 | 9.3 | 4.5 | 3.6 | 1.3 | 6.2 | 53 | 5.9 | 0 | 0 | 0 | 3 |
| 5 | 1.3 | 8.6 | 4.7 | 3.1 | 2.5 | 3.7 | 48 | 4.8 | 0 | 0 | 0 | 2 |
| 2 | 2.6 | 6.5 | 3.7 | 2.4 | 1.7 | 8.5 | 38 | 3.2 | 1 | 1 | 1 | 1 |
| 5 | 2.5 | 9.4 | 4.6 | 3.7 | 1.4 | 6.3 | 54 | 6 | 0 | 0 | 0 | 3 |
| 3.1 | 1.9 | 10 | 4.5 | 2.6 | 3.2 | 3.8 | 55 | 4.9 | 0 | 0 | 1 | 3 |
| 3.4 | 3.9 | 5.6 | 5.6 | 3.6 | 2.3 | 9.1 | 43 | 4.7 | 1 | 1 | 1 | 2 |
| 5.8 | 0.2 | 8.8 | 4.5 | 3 | 2.4 | 6.7 | 57 | 4.9 | 0 | 0 | 1 | 3 |
| 5.4 | 2.1 | 8 | 3 | 3.8 | 1.4 | 5.2 | 53 | 3.8 | 0 | 0 | 1 | 3 |
| 3.7 | 0.7 | 8.2 | 6 | 2.1 | 2.5 | 5.2 | 41 | 5 | 0 | 0 | 0 | 2 |
| 2.6 | 4.8 | 8.2 | 5 | 3.6 | 2.5 | 9 | 53 | 5.2 | 1 | 1 | 1 | 2 |
| 4.5 | 4.1 | 6.3 | 5.9 | 4.3 | 3.4 | 8.8 | 50 | 5.5 | 1 | 1 | 0 | 2 |
| 2.8 | 2.4 | 6.7 | 4.9 | 2.5 | 2.6 | 9.2 | 32 | 3.7 | 1 | 1 | 1 | 1 |
| 3.8 | 0.8 | 8.7 | 2.9 | 1.6 | 2.1 | 5.6 | 39 | 3.7 | 0 | 0 | 0 | 1 |
| 2.9 | 2.6 | 7.7 | 7 | 2.8 | 3.6 | 7.7 | 47 | 4.2 | 0 | 1 | 1 | 2 |
| 4.9 | 4.4 | 7.4 | 6.9 | 4.6 | 4 | 9.6 | 62 | 6.2 | 1 | 1 | 0 | 2 |
| 5.4 | 2.5 | 9.6 | 5.5 | 4 | 3 | 7.7 | 65 | 6 | 0 | 0 | 0 | 3 |
| 4.3 | 1.8 | 7.6 | 5.4 | 3.1 | 2.5 | 4.4 | 46 | 5.6 | 0 | 0 | 1 | 3 |
| 2.3 | 4.5 | 8 | 4.7 | 3.3 | 2.2 | 8.7 | 50 | 5 | 1 | 1 | 1 | 2 |
| 3.1 | 1.9 | 9.9 | 4.5 | 2.6 | 3.1 | 3.8 | 54 | 4.8 | 0 | 0 | 1 | 3 |
| 5.1 | 1.9 | 9.2 | 5.8 | 3.6 | 2.3 | 4.5 | 60 | 6.1 | 0 | 0 | 0 | 3 |
| 4.1 | 1.1 | 9.3 | 5.5 | 2.5 | 2.7 | 7.4 | 47 | 5.3 | 0 | 0 | 1 | 3 |
| 3 | 3.8 | 5.5 | 4.9 | 3.4 | 2.6 | 6 | 36 | 4.2 | 0 | 1 | 1 | 2 |
| 1.1 | 2 | 7.2 | 4.7 | 1.6 | 3.2 | 10 | 40 | 3.4 | 1 | 1 | 1 | 1 |
| 3.7 | 1.4 | 9 | 4.5 | 2.6 | 2.3 | 6.8 | 45 | 4.9 | 0 | 0 | 0 | 2 |
| 4.2 | 2.5 | 9.2 | 6.2 | 3.3 | 3.9 | 7.3 | 59 | 6 | 0 | 0 | 0 | 3 |
| 1.6 | 4.5 | 6.4 | 5.3 | 3 | 2.5 | 7.1 | 46 | 4.5 | 1 | 1 | 0 | 2 |
| 5.3 | 1.7 | 8.5 | 3.7 | 3.5 | 1.9 | 4.8 | 58 | 4.3 | 0 | 0 | 0 | 3 |
| 2.3 | 3.7 | 8.3 | 5.2 | 3 | 2.3 | 9.1 | 49 | 4.8 | 1 | 1 | 1 | 2 |
| 3.6 | 5.4 | 5.9 | 6.2 | 4.5 | 2.9 | 8.4 | 50 | 5.4 | 1 | 1 | 1 | 2 |
| 5.6 | 2.2 | 8.2 | 3.1 | 4 | 1.6 | 5.3 | 55 | 3.9 | 0 | 0 | 1 | 3 |
| 3.6 | 2.2 | 9.9 | 4.8 | 2.9 | 1.9 | 4.9 | 51 | 4.9 | 0 | 0 | 0 | 3 |
| 5.2 | 1.3 | 9.1 | 4.5 | 3.3 | 2.7 | 7.3 | 60 | 5.1 | 0 | 0 | 1 | 3 |
| 3 | 2 | 6.6 | 6.6 | 2.4 | 2.7 | 8.2 | 41 | 4.1 | 1 | 1 | 0 | 1 |
| 4.2 | 2.4 | 9.4 | 4.9 | 3.2 | 2.7 | 8.5 | 49 | 5.2 | 0 | 0 | 1 | 2 |
| 3.8 | 0.8 | 8.3 | 6.1 | 2.2 | 2.6 | 5.3 | 42 | 5.1 | 0 | 0 | 0 | 2 |
| 3.3 | 2.6 | 9.7 | 3.3 | 2.9 | 1.5 | 5.2 | 47 | 5.1 | 0 | 0 | 1 | 3 |
| 1 | 1.9 | 7.1 | 4.5 | 1.5 | 3.1 | 9.9 | 39 | 3.3 | 1 | 1 | 1 | 1 |
| 4.5 | 1.6 | 8.7 | 4.6 | 3.1 | 2.1 | 6.8 | 56 | 5.1 | 0 | 0 | 0 | 3 |
| 5.5 | 1.8 | 8.7 | 3.8 | 3.6 | 2.1 | 4.9 | 59 | 4.5 | 0 | 0 | 0 | 3 |
| 3.4 | 4.6 | 5.5 | 8.2 | 4 | 4.4 | 6.3 | 47 | 5.6 | 0 | 1 | 1 | 2 |
| 1.6 | 2.8 | 6.1 | 6.4 | 2.3 | 3.8 | 8.2 | 41 | 4.1 | 1 | 1 | 0 | 1 |
| 2.3 | 3.7 | 7.6 | 5 | 3 | 2.5 | 7.4 | 37 | 4.4 | 0 | 1 | 0 | 1 |
| 2.6 | 3 | 8.5 | 6 | 2.8 | 2.8 | 6.8 | 53 | 5.6 | 1 | 1 | 0 | 2 |
| 2.5 | 3.1 | 7 | 4.2 | 2.8 | 2.2 | 9 | 43 | 3.7 | 1 | 1 | 1 | 1 |
| 2.4 | 2.9 | 8.4 | 5.9 | 2.7 | 2.7 | 6.7 | 51 | 5.5 | 1 | 1 | 0 | 2 |
| 2.1 | 3.5 | 7.4 | 4.8 | 2.8 | 2.3 | 7.2 | 36 | 4.3 | 0 | 1 | 0 | 1 |
| 2.9 | 1.2 | 7.3 | 6.1 | 2 | 2.5 | 8 | 34 | 4 | 1 | 1 | 1 | 1 |
| 4.3 | 2.5 | 9.3 | 6.3 | 3.4 | 4 | 7.4 | 60 | 6.1 | 0 | 0 | 0 | 3 |
| 3 | 2.8 | 7.8 | 7.1 | 3 | 3.8 | 7.9 | 49 | 4.4 | 0 | 1 | 1 | 2 |
| 4.8 | 1.7 | 7.6 | 4.2 | 3.3 | 1.4 | 5.8 | 39 | 5.5 | 0 | 0 | 0 | 2 |
| 3.1 | 4.2 | 5.1 | 7.8 | 3.6 | 4 | 5.9 | 43 | 5.2 | 0 | 1 | 1 | 2 |
| 1.9 | 2.7 | 5 | 4.9 | 2.2 | 2.5 | 8.2 | 36 | 3.6 | 1 | 1 | 0 | 1 |
| 4 | 0.5 | 6.7 | 4.5 | 2.2 | 2.1 | 5 | 31 | 4 | 0 | 0 | 1 | 1 |
| 0.6 | 1.6 | 6.4 | 5 | 0.7 | 2.1 | 8.4 | 25 | 3.4 | 1 | 1 | 1 | 1 |
| 6.1 | 0.5 | 9.2 | 4.8 | 3.3 | 2.8 | 7.1 | 60 | 5.2 | 0 | 0 | 1 | 3 |
| 2 | 2.8 | 5.2 | 5 | 2.4 | 2.7 | 8.4 | 38 | 3.7 | 1 | 1 | 0 | 1 |
| 3.1 | 2.2 | 6.7 | 6.8 | 2.6 | 2.9 | 8.4 | 42 | 4.3 | 1 | 1 | 0 | 1 |
| 2.5 | 1.8 | 9 | 5 | 2.2 | 3 | 6 | 33 | 4.4 | 0 | 0 | 0 | 1 |
In: Statistics and Probability
Karantika Ltd operates at capacity and makes glass-topped coffee table. At the end of 2019, Karantika Ltd’s management accountant gathered the following data to prepare budgets for the first six months 2020:
Unit sales Price per unit
January 2,700 $400
February 2,600 $400
March 2,800 $550
April 2,600 $550
May 2,650 $500
June 2,600 $500
July 3,000 $500
August 3,000 $550
Sales on November 2019 were 2,500 units and on December 2,400 units at a selling price of $450.
20% of sales are cash sales and 80% are credit sales. From experience, Karantika Ltd collected 40% of credit sales within the month of sale, 30% in the following month and 25% in two months after the month of sale. 5% of credit sales is uncollectable. The bad debt is calculated at the end of six month.
|
BI (1/1/19) |
EI (end of each month) |
|---|---|
|
Tables:500 (at $210/unit) |
20% of following month estimated sales |
|
Wood: 1,400 b.m. |
25% b.m. needed for next month’s budgeted production (units) |
|
Glass 500 sheets |
20% sheets needed for next month’s budgeted production (units) |
Direct materials:
Wood: 2 board meters (b.m.) per table
Glass: 1 sheet per table
Direct manufacturing labour: 4 hours per table
Wood: $16 per b.m.
Glass: $22 per sheet
Direct labour: $25 per labour-hour
January: Loan for $40,000 plus interest payable at 31 December 2019 for $2,000 were paid on 2 January 2020.
End of January: Dividends $100,000
Beginning of May: Purchase of land $200,000
Beginning of June: Purchase of equipment for $300,000. Estimated of useful life 5 year with zero residual value.
|
ASSETS |
LIABILITIES |
||
|---|---|---|---|
|
Cash |
32,000 | Accounts payable ** | 64,000 |
|
Accounts receivable * |
700,200 | Interest payable | 2,000 |
|
Inventory: Wood |
22,400 | Loan payable | 40,000 |
|
Inventory: Glass |
11,000 | SHAREHOLDER’S EQUITY | |
|
Inventory: Finished goods |
105,000 | Share capital | 801,600 |
|
Plant and equipment, net |
450,000 | Retained earnings | 413,000 |
|
Total assets |
1, 320,600 | Total Liabilities and Shareholder’s equity | 1,320,600 |
*At the beginning of the year there is no allowance of doubtful debt
** Account payable is from the direct material purchase.
Required:
Prepare a monthly master budget for Karantika Ltd’s for the first semester 2020. The following component budgets must be included ( round the number with two decimals):
Note. There is no beginning and ending balance of WIP in each month.
Can you please answer question number 12.In: Accounting
Karantika Ltd operates at capacity and makes glass-topped coffee table. At the end of 2019, Karantika Ltd’s management accountant gathered the following data to prepare budgets for the first six months 2020:
Unit sales Price per unit
January 2,700 $400
February 2,600 $400
March 2,800 $550
April 2,600 $550
May 2,650 $500
June 2,600 $500
July 3,000 $500
August 3,000 $550
Sales on November 2019 were 2,500 units and on December 2,400 units at a selling price of $450.
20% of sales are cash sales and 80% are credit sales. From experience, Karantika Ltd collected 40% of credit sales within the month of sale, 30% in the following month and 25% in two months after the month of sale. 5% of credit sales is uncollectable. The bad debt is calculated at the end of six month.
|
BI (1/1/19) |
EI (end of each month) |
|---|---|
|
Tables:500 (at $210/unit) |
20% of following month estimated sales |
|
Wood: 1,400 b.m. |
25% b.m. needed for next month’s budgeted production (units) |
|
Glass 500 sheets |
20% sheets needed for next month’s budgeted production (units) |
Direct materials:
Wood: 2 board meters (b.m.) per table
Glass: 1 sheet per table
Direct manufacturing labour: 4 hours per table
Wood: $16 per b.m.
Glass: $22 per sheet
Direct labour: $25 per labour-hour
January: Loan for $40,000 plus interest payable at 31 December 2019 for $2,000 were paid on 2 January 2020.
End of January: Dividends $100,000
Beginning of May: Purchase of land $200,000
Beginning of June: Purchase of equipment for $300,000. Estimated of useful life 5 year with zero residual value.
|
ASSETS |
LIABILITIES |
||
|---|---|---|---|
|
Cash |
32,000 | Accounts payable ** | 64,000 |
|
Accounts receivable * |
700,200 | Interest payable | 2,000 |
|
Inventory: Wood |
22,400 | Loan payable | 40,000 |
|
Inventory: Glass |
11,000 | SHAREHOLDER’S EQUITY | |
|
Inventory: Finished goods |
105,000 | Share capital | 801,600 |
|
Plant and equipment, net |
450,000 | Retained earnings | 413,000 |
|
Total assets |
1, 320,600 | Total Liabilities and Shareholder’s equity | 1,320,600 |
*At the beginning of the year there is no allowance of doubtful debt
** Account payable is from the direct material purchase.
Required:
Prepare a monthly master budget for Karantika Ltd’s for the first semester 2020. The following component budgets must be included ( round the number with two decimals):
Note. There is no beginning and ending balance of WIP in each month.
In: Accounting