Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the master budget and has accumulated the following information for 2020.
January |
February |
March |
April |
May |
||||||
Estimated unit sales | 10,800 | 11,100 | 8,700 | 8,400 | 8,000 | |||||
Sales price per unit | $50.50 | $48.20 | $48.20 | $48.20 | $48.20 | |||||
Direct labor hours per unit | 2.0 | 2.0 | 1.5 | 1.5 | 1.5 | |||||
Wage per direct labor hour | $9 | $9 | $9 | $10 | $10 |
Lowell has a labor contract that calls for a wage increase to $10
per hour on April 1. New labor-saving machinery has been installed
and will be fully operational by March 1.
Lowell expects to begin the year with 16,350 frames on hand and has
a policy of carrying an end-of-month inventory of 100% of the
following month’s sales, plus 50% of the second following month’s
sales.
Prepare a production budget for Lowell Company by month and for the first quarter of the year.
LOWELL COMPANY |
||||||||
Jan |
Feb |
Mar |
Total |
|||||
Total Materials RequiredDesired Ending Direct MaterialsDirect Materials PurchasesRequired Production UnitsTotal Required UnitsDesired Ending Finished Goods UnitBeginning Direct MaterialsDirect Materials Per UnitBeginning Finished Goods UnitExpected Unit Sales |
||||||||
AddLess: Total Materials RequiredRequired Production UnitsTotal Required UnitsExpected Unit SalesDesired Ending Direct MaterialsDirect Materials Per UnitDirect Materials PurchasesBeginning Finished Goods UnitDesired Ending Finished Goods UnitBeginning Direct Materials |
||||||||
Desired Ending Finished Goods UnitRequired Production UnitsBeginning Direct MaterialsDirect Materials Per UnitDesired Ending Direct MaterialsTotal Required UnitsExpected Unit SalesTotal Materials RequiredDirect Materials PurchasesBeginning Finished Goods Unit |
||||||||
AddLess: Total Required UnitsTotal Materials RequiredExpected Unit SalesBeginning Finished Goods UnitRequired Production UnitsDirect Materials Per UnitDirect Materials PurchasesBeginning Direct MaterialsDesired Ending Direct MaterialsDesired Ending Finished Goods Unit |
||||||||
Desired Ending Direct MaterialsBeginning Direct MaterialsRequired Production UnitsBeginning Finished Goods UnitDirect Materials Per UnitTotal Required UnitsTotal Materials RequiredExpected Unit SalesDesired Ending Finished Goods UnitDirect Materials Purchases |
eTextbook and Media
Prepare a direct labor budget for Lowell Company by month and for the first quarter of the year. The direct labor budget should include direct labor hours. (Round Direct labor hours per unit answers to 1 decimal place, e.g. 52.7.)
LOWELL COMPANY |
|||||||||
Jan |
Feb |
Mar |
Total |
||||||
Total Materials RequiredDirect Labor Time (Hours) Per UnitCost Per PoundTotal Pounds Required for ProductionTotal Direct Labor CostDirect Materials PurchasesDesired Ending InventoryTotal Required Direct Labor HoursDirect Materials Per UnitDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesBeginning Materials InventoryUnits to be Produced |
|||||||||
Direct Materials PurchasesBeginning Materials InventoryCost Per PoundDirect Labor Cost Per HourDirect Labor Time (Hours) Per UnitTotal Cost of Direct Materials PurchasesDirect Materials Per UnitTotal Materials RequiredTotal Direct Labor CostTotal Required Direct Labor HoursTotal Pounds Required for ProductionUnits to be ProducedDesired Ending Inventory |
|||||||||
Direct Labor Time (Hours) Per UnitTotal Materials RequiredDirect Materials PurchasesDirect Materials Per UnitTotal Required Direct Labor HoursBeginning Materials InventoryTotal Direct Labor CostCost Per PoundDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesDesired Ending InventoryUnits to be ProducedTotal Pounds Required for Production |
|||||||||
Total Required Direct Labor HoursTotal Direct Labor CostDirect Labor Cost Per HourCost Per PoundBeginning Materials InventoryUnits to be ProducedDirect Labor Time (Hours) Per UnitDirect Materials PurchasesTotal Cost of Direct Materials PurchasesDirect Materials Per UnitDesired Ending InventoryTotal Materials RequiredTotal Pounds Required for Production |
$ |
$ |
$ |
||||||
Cost Per PoundDirect Materials Per UnitTotal Cost of Direct Materials PurchasesDirect Materials PurchasesBeginning Materials InventoryUnits to be ProducedTotal Materials RequiredDirect Labor Cost Per HourTotal Required Direct Labor HoursDirect Labor Time (Hours) Per UnitDesired Ending InventoryTotal Pounds Required for ProductionTotal Direct Labor Cost |
$ |
$ |
$ |
$ |
In: Accounting
Mesmerizing Marketers (MM) is a marketing company that offers a variety of marketing offerings to its customers. Specifically:
• MM will create a TV commercial for $1M, build an app for $500K, and build a Facebook page for $250K. These amounts represent MM’s charges for these items when MM sells them separately to customers. The TV commercial, the app, and the Facebook page are not interrelated; that is, each functions independently of the other offerings.
• If a customer purchases all aforementioned items together, the total cost is $1.5M. Payment terms are 50 percent consideration due at contract signing, with the remaining 50 percent due over the rest of the development period (25 percent at mid-point, 25 percent at completion).
• If the app is downloaded 500K times or more in the first month, there is a one-time bonus of $250K payable to MM.
Stone, a customer, approaches MM with the hopes of reinventing its image to a younger customer base. Stone has a verbal agreement with MM that is based on MM’s unsigned quote to Stone on November 30, 20X5, for one TV commercial, one app, and a Facebook page. The agreement creates enforceable rights and obligations pursuant to MM’s customary business practices. None of these items can be redirected by MM to another customer. MM performed a credit check on Stone and has determined that Stone has the intention and ability to pay MM for fulfilling its portion of the contract. Stone is required to pay MM for performance completed to date if Stone cancels the contract with MM for reasons other than MM’s failure to perform under the contract as promised.
Stone makes a payment on November 30, 20X5, in the amount of $750K pursuant to the agreement. From the date of the quote, it takes MM six months to develop and produce the TV commercial, two weeks to complete the Facebook page, and three months to complete a fully functioning app. MM does not think that the app will be downloaded 500K times in the first month because Stone’s customer base does not quickly accept newly developed technology. On the basis of its experience with similar technology, MM has determined that it takes over three months for Stone’s users to begin to download its apps.
Required
MM’s CFO is trying to understand the new revenue recognition model and has asked you to explain how MM would account for the above scenario under the new standard.
1. How should MM account for the above offering with Stone under the new revenue recognition model?
2. How would your conclusions change if: a. The app sold to Stone is actually downloaded more than 500K times in the first month?
In: Accounting
Pronghorn produces one single product, a small reading tablet,
and sells it at $100 per unit. Its current annual sales are
$200,000. Its annual fixed costs include factory rent, $38,000;
depreciation expense; equipment, $10,000; utilities, $18,000;
insurance, $8,000. Its variable costs include materials, $30 per
unit, and direct labour, $40 per unit. Pronghorn’s income tax rate
is 20%.
1.What is the contribution margin per unit?
2.What is the contribution margin ratio?
3.How many units must Pronghorn sell to break even?
4.If Pronghorn would like to earn a profit after tax of $11,000, what should the sales be? At this sales level, what is the degree of operating leverage? What is the margin of safety in unit?
5.If Pronghorn would like to earn a profit after tax that is 8% of sales, what should the sales be? How many units does Pronghorn need to increase from the current sales level?
In: Accounting
Whitelands, Inc. had $100 of cash and shareholders’ equity as the
result of its initial sale of stock on January 1, 2012. During its
first month of operations, Whitelands had the following operating
transactions:
Date |
Transaction |
1/1 |
Paid $24 cash in advance to rent a store for one year |
1/1 |
Purchased 2 units of inventory on credit costing $4 each |
1/3 |
Purchased 3 units of inventory on credit costing $5 each |
1/10 |
Purchased 4 units of inventory on credit costing $6 each |
1/21 |
Paid for the January 1 inventory purchase |
1/23 |
Paid for the January 3 inventory purchase |
1/30 |
Sold 7 units of inventory at $10 each on credit |
1/30 |
Matched the inventory cost to January 30 sales on a FIFO basis |
1/31 |
Estimated that 10% of credit sales will not be realized in cash |
1/31 |
Adjusted the prepaid rent account |
Required:
Record the journal entries for the above transactions.
Present Whitelands’ income statement for January 2014.
Report Whitelands’ balance sheet on January 31, 2014.
Close the revenue and expense accounts to retained earnings.
In: Accounting
1. the chief audit executive has noticed that some staff auditors have become more proficient in the use of personal computers while other auditors want nothing to do with them. the executive should:
A. disregard the differences
B. Provide training for those individuals interested in improving their skills
C. Discipline the individuals who display no self starting abilities
D. Establish a program for developing the capabilities of the entire internal audit department
In: Accounting
Case 2.2
Business Case: Data Chaos Creates Risk
Data chaos often runs rampant in service organizations, such as health care and the government. For example, in many hospitals, each line of business, division, and department has implemented its own IT applications, often without a thorough analysis of its relationship with other departmental or divisional systems. This arrangement leads to the hospital having IT groups that specifically manage a particular type of application suite or data silo for a particular department or division.
Data Management
When applications are not well managed, they can generate terabytes of irrelevant data, causing hospitals to drown in such data. This data chaos could lead to medical errors. In the effort to manage excessive and massive amounts of data, there is increased risk of relevant information being lost (missing) or inaccurate—that is, faulty or dirty data. Another risk is data breaches.
Accountability in health-care demands compliance with strong data governance efforts. Data governance programs verify that data input into EHR, clinical, financial, and operational systems are accurate and complete—and that only authorized edits can be made and logged.
Vanderbilt University Medical Center Adopts EHR and Data Governance
Vanderbilt University Medical Center (VUMC) in Nashville, TN, was an early adopter of EHR and implemented data governance in 2009. VUMC’s experience provides valuable lessons.
VUMC consists of three hospitals and the Vanderbilt Clinic, which have 918 beds, discharge 53,000 patients each year, and count 1.6 million clinic visits each year. On average, VUMC has an 83% occupancy rate and has achieved HIMSS Stage 6 hospital EHR adoption. HIMSS (Healthcare Information and Management Systems Society, himss.org) is a global, nonprofit organization dedicated to better health-care outcomes through IT. There are seven stages of EHR adoption, with Stage 7 being a fully paperless environment. That means all clinical data are part of an electronic medical record and, as a result, can be shared across and outside the enterprise. At Stage 7, the health-care organization is getting full advantage of the health information exchange (HIE). HIE provides interoperability so that information can flow back and forth among physicians, patients, and health networks (NextGen Healthcare, 2016).
VUMC began collecting data as part of its EHR efforts in 1997. By 2009, the center needed stronger, more disciplined data management. At that time, hospital leaders initiated a project to build a data governance infrastructure.
Data Governance Implementation
VUMC’s leadership team had several concerns.
Health Record Executive Committee
Initially, VUMC’s leaders assigned data governance to their traditional medical records committee, but that approach failed. Next, they hired consultants to help develop a data governance structure and organized a health record executive committee to oversee the project. The committee reports to the medical board and an executive committee to ensure executive involvement and sponsorship. The committee is responsible for developing the strategy for standardizing health record practices, minimizing risk, and maintaining compliance. Members include the chief medical information officer (CMIO), CIO, legal counsel, medical staff, nursing informatics, HIM, administration, risk management, compliance, and accreditation. In addition, a legal medical records team was formed to support additions, corrections, and deletions to the EHR. This team defines procedures for removal of duplicate medical record numbers and policies for data management and compliance.
Costs of Data Failure
Data failures incur the following costs:
Benefits Achieved from Data Governance
As in other industries, in health care, data are the most valuable asset. The handling of data is the real risk. EHRs are effective only if the data are accurate and useful to support patient care. Effective ongoing data governance has achieved that goal at VUMC.
Questions
Sources: Compiled from NextGen Healthcare (2016), Office of the National Coordinator for HIT (2016), and Conn (2016).
In: Accounting
Employee #1 Colin Forth, 40 years old
Annual Salary $80,000
Married with a 10-year-old son
Studied part-time at Humber College for 2 months, and paid tuition fees of $1,500.
Spouse, Emma has $65,000 income
Employee #2 Renata Hoover, 45 years old
Annual Salary $70,000
Studied full-time at University of Toronto for 4 months, paid tuition fees of $4,500
Renata’s 75-year-old father lives with her. Her father qualifies for disability tax credit and has no income.
Both employees have been employed since January 1, 2019.
Pay period—Semi-monthly (for example Jan. 2019 is paid on Jan.15, 2019 & Jan.31 2019).
complete the chart below
Employee | ANNUAL | Semi-monthly | GROSS | CPP | EI | FEDERAL | PROVINCIAL | Total Taxes | NET |
Jul.15, 2019 | |||||||||
Colin Forth | |||||||||
Renata Hoover | |||||||||
Total | |||||||||
Jul.31, 2019 | |||||||||
Colin Forth | |||||||||
Renata Hoover | |||||||||
Total | |||||||||
Total (Jul,2019) | |||||||||
Payroll Tax Deduction | |||||||||
Jul.15, 2019 | |||||||||
Total employee portion | |||||||||
Total employer portion | |||||||||
Total remittance | |||||||||
Jul.31, 2019 | |||||||||
Total employee portion | |||||||||
Total employer portion | |||||||||
Total remittance |
In: Accounting
3.
Morris Industries manufactures and sells three products (AA, BB, and CC). The sales price and unit variable cost for the three products are as follows:
Product | Sales Price per Unit |
Variable Cost per Unit |
AA | $55 | $25 |
BB | 45 | 20 |
CC | 30 | 5 |
Their sales mix is reflected as a ratio of 5:3:2. Annual fixed costs shared by the three products are $275,000 per year.
A. What are total variable costs for Morris with their current product mix?
Total variable costs $
B. Calculate the number of units of each product that will need to be sold in order for Morris to break even.
Number of Units per Product |
|||
AA | |||
BB | |||
CC |
C. What is their break-even point in sales dollars?
Break-even point in sales $
D. Using an income statement format, prove that this is the break-even point. If an amount is zero, enter "0".
Income Statement | |
Sales | |
Product AA | $ |
Product BB | |
Product CC | |
Total Sales | $ |
Variable Costs | |
Product AA | $ |
Product BB | |
Product CC | |
Total Variable Costs | $ |
Contribution Margin | $ |
Fixed Costs | |
Net Income | $ |
In: Accounting
Smokey and the Bandit produces outdoor activity clothing. The product line consists of pants, jackets, tops, and accessories. Data has been collected related to direct materials and direct labor for the four product lines. Smokey and the Bandit has also collected information on four possible cost drivers (units, batches, machine hours, labor hours). All this information is listed below. Construct a spreadsheet that will allocate overhead for each of these alternative drivers and will calculate the total per unit cost for each product line. Use the VLOOKUP function (show them) when constructing the spreadsheet so that you can determine the effect of different cost drivers on the overhead allocated and the resulting cost per unit.
Product Line |
Units |
Average Sales Price per unit |
Total Material Cost |
Total Labor Cost |
|
Pants |
4,600 |
$73 |
$234,600 |
$20,115 |
|
Jackets |
2,500 |
$98 |
$145,000 |
$25,200 |
|
Tops |
9,800 |
$36 |
$156,800 |
$32,970 |
|
Accessories |
18,500 |
$12 |
$ 37,000 |
$15,210 |
Product Line |
Batches |
Machine Hours |
Labor Hours |
|||
Pants |
42 |
1,640 |
1,341 |
|||
Jackets |
26 |
1,730 |
1,400 |
|||
Tops |
78 |
2,600 |
2,198 |
|||
Accessories |
95 |
2,250 |
845 |
Total overhead cost to be allocated: $321,560
After constructing your spreadsheet answer the following questions?
In: Accounting
Pls do not handwritten for easy reading === ===
Question:-
CC Ltd, a company incorporated in Singapore with Dec 31 year ends,
acquired a retail shop on 2 Jan 20x1 for $600,000 with the
intention of renting it out. The property is leasehold with 20
years remaining on the lease. It has a zero residual value. On 1
Jul 20x1, CC Ltd rented out the retails shop to an unrelated
company for a monthly rental of $8,000, payable at the end of each
month. After 2 yrs, CC Ltd managed to terminate the lease with the
existing tenant on 30 Jun 20x3. CC Ltd used the retail shop for its
own operations from 1 Jul 20x3 onwards.
The market value of CC Ltd's retail shop was determined as
follows:-
31 Dec 20x1: $800,000
31 Dec 20x2: $700,000
1 Jul 20x3 : $740,000
CC Ltd adopts the fair model under FRS 40 Investment Property and
adopts the cost model under FRS 16 Property, Plant and equipment.
CC Ltd depreciates all its assets on a straight-line where
applicable.
Required:
Illustrate the accounting for the retail shop by preparing the
journal entries(with journal narratives) to record the various
events relating to CC Ltd's retail shop from 2 Jan 20x1 to 31 Dec
20x3. Please round your answer to the nearest dollar.
In: Accounting
Walter's Inc. began operations on January 15, 2018, and had the following transactions in trading securities during 2018 and 2019:
March 1, 2018 Purchased 500 shares of Apex, Inc. common stock at $11 per share, plus a commission of $300
April 1, 2018 Purchased 1,000 shares of Basic Corp. preferred stock at $4 per share, plus a commission of $500.
June 1, 2018 Received dividends of $1 per share on the Apex stock and $2 per share on the Basic stock
December 31, 2018 Determined that the fair market values per share were $13 for the Apex sstock and $2 for the Basic stock.
February 15, 2019 Sold 500 shares of the Basic stock for $3 per share, less commissions of $200.
June 1, 2019 Received dividends of $1 per share on the Apex stock and $2 per share on the Basic stock
November 20, 2019 Purchased 800 share of Cargo, Inc. common stock for $7 per share, plus a commission of $400.
December 31, 2019 Determined that the fair market values per share were $14 for the Apex stock, $3 for the Basic stock, and $8 for the Cargo stock.
REQUIRED:
Prepare all of the journal entries required to account for Walter's transactions in the trading securities for the years 2018 and 2019.
In: Accounting
assignment
Wanda wants all of her employees to be motivated to do a good job and continue the success of Salty Pawz, but there is only so much money she can shell out and still keep the business profitable. She begins to wonder if there aren’t ways she can motivate her employees without writing yet another check.
Recently she was asked to donate dog treats to the local Humane Society for a free rabies vaccination clinic they were holding at the high school. Wanda donated 100 bags of Chicken Cuties and even stopped by the event to see how it was going. When she arrived, she was surprised to see her friend Jamie there, happily greeting and signing in owners and their dogs. On the way home Wanda begins to think that perhaps there are ways that she can motivate her employees without paying them, but she doesn’t really know all that much about motivation theory. She turns to you once again for information and guidance.
Your Task
In: Accounting
Translation and Remeasurement of Depreciable Assets
Massmart, the second largest retailer in Africa, is a subsidiary of Wal-Mart Inc., a U.S. company. Massmart reports its accounts in its local currency, the rand (R). Wal-Mart’s fiscal year ends January 31. On February 1, 2018, Massmart reports facilities with original cost of R500 million and accumulated depreciation of R280 million in its noncurrent assets, as follows:
• Buildings acquired at a cost of R175 million when the exchange rate was $0.15/R, with accumulated depreciation of R100 million. The buildings are being depreciated on a straight-line basis over 25 years.
• Equipment acquired at a cost of R325 million when the exchange rate was $0.12/R, with accumulated depreciation of R180 million. The equipment is being depreciated on a straight-line basis over 10 years.
Additional exchange rates:
February 1, 2018 | $0.10 |
Average for fiscal 2019 | 0.08 |
January 31, 2019 | 0.07 |
Massmart still holds these facilities at January 31, 2019.
Required
a. Assume that Massmart’s functional currency is the rand. Calculate Massmart’s translated facilities, at cost, and related accumulated depreciation, at January 31, 2019, and its translated depreciation expense for fiscal 2019.
b. Now assume that Massmart’s functional currency is the U.S. dollar. Calculate Massmart’s remeasured facilities, at cost, and related accumulated depreciation, at January 31, 2019, and its remeasured depreciation expense for fiscal 2019.
Enter answers using all zeros (do not abbreviate to millions or thousands).
a. Translated | b. Remeasured | ||
---|---|---|---|
Facilities, at cost | Answer | Answer | |
Accumulated depreciation | Answer | Answer | |
Depreciation expense | Answer | Answer |
In: Accounting
1. Rose Company has a relevant range of production between 10,000 and 25,000 units. The following cost data represents average cost per unit for 15,000 units of production.
Average Cost per Unit |
|
Direct Materials | $13 |
Direct Labor | 10 |
Indirect Materials | 1 |
Fixed manufacturing overhead | 5 |
Variable manufacturing overhead | 2 |
Fixed selling and administrative expenses | 8 |
Variable sales commissions | 25 |
Using the cost data from Rose Company, answer the following questions:
A. If 10,000 units are produced, what is the variable cost per unit?
Variable cost per unit $
B. If 17,000 units are produced, what is the variable cost per unit?
Variable cost per unit $
C. If 21,000 units are produced, what are the total variable costs?
Total variable costs $
D. If 11,000 units are produced, what are the total variable costs?
Total variable costs $
E. If 20,000 units are produced, what are the total manufacturing overhead costs incurred?
Total manufacturing overhead costs $
F. If 24,000 units are produced, what are the total manufacturing overhead costs incurred?
Total manufacturing overhead costs $
G. If 20,000 units are produced, what are the per unit manufacturing overhead costs incurred? If required, round final answer to two decimal places.
Manufacturing overhead costs per unit $
H. If 25,000 units are produced, what are the per-unit manufacturing overhead costs incurred? If required, round final answer to two decimal places.
Manufacturing overhead costs per unit $
In: Accounting
Pls do not handwritten for easy reading === ===
Question:-
1a) The Singapore "Conceptual Framework for Financial Reporting" on
qualitative characteristics deals with the attributes that make
financial information useful.
Explain the following 2 qualitative characteristics: (i) Relevance
and (ii) Verifiability
1b)Under FRS 115 Revenue from contracts with customers an entity
recognizes revenue over time when it transfers control of a good or
service over time and, therefore, satisfies a performance
obligation over time. For measuring progress towards complete
satisfaction of a performance obligation over time, the entity can
choose to use the output or input method. Explain and illustrate
with suitable examples of what these methods are.
In: Accounting