I need help with these study problems. Thank you.
Maintenance department costs:
Budgeted operating costs per month $80,000
plus cost per machine-hour $0.50
Machine tools division 65%
Special products division 35%
October estimates of machine-hour activity:
Machine tools division 90,000
Special products division 60,000
October actual machine-hour activity:
Machine tools division 60,000
Special products division 60,000
Actual October costs:
Maintenance department fixed costs $85,000
Maintenance department variable costs $78,000
(1) Cost to Machine Tools Division $81,500
For the Month Ended May 31
Variable expenses 408,000
Contribution margin 492,000
Fixed expenses 465,000
Net operating income $27,000
Central Territory sales $400,000
Central Territory variable expenses $208,000
Central Territory fixed expenses $160,000
Eastern Territory fixed expenses $130,000
Awls sales $100,000
Pows sales $300,000
Awls variable expenses 25%
Pows variable expenses 61%
Awls fixed expenses, Central Territory $60,000
Pows fixed expenses, Central Territory $54,000
(1) Central segment margin $32,000
Income Statement for Last Month:
(Brazilian currency Real)
Company Cloth Leather
Sales 3,500,000 2,000,000 1,500,000
Variable expenses 1,721,000 960,000 761,000
Contribution margin 1,779,000 1,040,000 739,000
Traceable fixed expenses:
Advertising 612,000 300,000 312,000
Administration 427,000 210,000 217,000
Depreciation 229,000 115,000 114,000
Total traceable fixed expenses 1,268,000 625,000 643,000
Divisional segment margin 511,000 415,000 96,000
Common fixed expenses 390,000
Net operating income 121,000
Leather Division Product Lines
Garments Shoes Handbags
Sales 500,000 700,000 300,000
Traceable fixed expenses:
Advertising 80,000 112,000 120,000
Administration 30,000 35,000 42,000
Depreciation 25,000 56,000 33,000
Variable expenses as a percentage of sales 65% 40% 52%
Common administrative expenses 110,000
Sales 200,000 100,000
Traceable fixed expenses:
Advertising 40,000 80,000
Variable expenses as a percentage of sales 43% 70%
Possible increase sales of garment line 200,000
Possible increase sales of shoe line 145,000
Campaign cost 30,000
The solution explains three problems in budgeting - Northstar Company, Savero S.A., and Reston Company
Audit Case: Smacker Dog Foods
Discuss the audit planning and risk assessment of the case below. Also speak to the course of action required regarding the audit.
Smackey Dog Foods, Inc - Scenario Summary
Smackey Dog Foods, Inc. started in the kitchen of Sarah, Kim, and Jillian's family home in the suburbs of Chicago. The three sisters initially bought the ingredients for their natural dog food recipes from the local grocery store. They used their dogs and the neighborhood dogs as their taste testers. Their dog food products were so good, the local kennels and veterinary offices were glad to distribute the sisters' products to their customers.
Local demand increased significantly. Local pet stores and small grocery stores discovered the products and became distributors. The sisters moved the expanding business into a larger facility and hired a few more workers. While their competitors' sales were flat or declining, Smackey Dog Food, Inc.'s sales were on a vertical climb!
Sales were so good last year, that the sisters opened a boutique division named Best Boy Gourmet, specializing in freshly manufactured, one-serving packages meant for consumption no later than 3 days after production. They sell this product at 3 times the cost of their other products and by special order only through their new website. Demand is high, but waste has been an issue.
Sarah is the president and general manager of the operation. Sarah has been very proactive in growing the business. She has met with her banker to discuss expanding the facilities and equipment with another $150,000 loan. Their first loan for $150,000 was secured by the industrial size, food production equipment purchased with the loan. The banker now demands an audit of the corporate financial statements before releasing another loan to the company. Sarah has offered to place the corporate account receivables up as collateral to secure the second loan. Based on revenue projections by her sister Jillian's sales team, Sarah believes that the company will not have trouble paying down the loan in a short period of time.
Kim manages the production operations. She oversees the inventory, production, and shipment of dog food products. The Best Boy Gourmet line has taken almost all of her attention lately. The winter holidays are approaching and sales demand based on forecasts from the sales force are higher than ever. Attaining fresh, raw ingredients is more difficult in the winter months. If any of the fresh ingredients are delayed, production comes to a standstill. There has been significant inventory waste as a result.
Kim's assistant, Henry, monitors the production and shipment of Smackey Dog Food's regular line of product. Henry takes pride in his work and is involved in every facet of the operation. With only one other warehouse employee to help, Henry personally is involved in preparing and approving all inventory records. Henry ensures that very little finished inventory sits in the warehouse. However, the shipping dock always seems to be full of returned dog food that should be restocked. When Kim asks him about it, Henry laughs and tells her that "first in first out" applies to dog food returns as well. Kim smiles and just accepts that answer.
Jillian is not very good at understanding accounting. The sisters placed Jillian in charge of sales. She manages a sales team of 12 salesmen in Illinois, Indiana, and Wisconsin. Her fear of flying and poor driving skills limit her ability to get around to the areas outside of Chicago. As a result, she has placed a lot of faith in her sales team. The sales team complained last year that they did not like waiting for their commissions until after bookkeeping calculated the actual revenues. In order to keep their spirits fired up, Jillian has her sales people project what their sales will be in the upcoming quarter and she pays commissions in advance on those projections. The sales team loves her and Jillian loves their approval. Jillian has noticed that the projections typically are off by 11% on average.
The employees of Smackey Dog Food, Inc. all own dogs. It was a hiring requirement on the job application. One employee was fired when it was discovered she never owned a dog when she was hired. A lawsuit is pending by the fired employee.
At this time, the receivables represent 29% of the corporate assets. The Chicago retail chain Pup Stores, Co. is Smackey Dog Food's largest buyer. They alone represent 31% of overall sales and usually pay within 30 days. However, Pup Stores is facing a major lawsuit from an animal rights group. The legal fees are eating into their cash reserves and they are facing some store closures.
The accounts receivable aging indicates that 38% of the receivables are 30 days or less. Twenty-two percent are 31-60 days. Twenty-one percent of the receivables are 61-90 days old. Ten percent are 90-120 days. The remaining receivables are older than 120 days. Sarah has not written off any of the receivables, nor will she.
Sales are projected to steadily grow at 16% next year if the company does not expand its facilities. With the expansion, sales are projected, rising 26%, with the most significant jump in the last quarter after expansion is completed and holiday sales pick up.
You and your firm, NorthStar CPAs, have never audited a dog food manufacturer. Although it is late in the year to be accepting a new calendar year-end audit, you need the work and have the time to devote to the audit before your 2-week sailing vacation in February.
You begin the audit process just prior to year-end by sending your audit manager, Pete, and two audit staffers, Ben and Maureen, out to the client. They spend time assessing the client and planning the audit.
During the first month of field work after year end, Ben and Maureen note that the dog food bags piled high on the docks are marked "Returned." One employee is seen throwing bags of the premium Best Boy Gourmet dog food into the dumpster in the morning and pulling it out and throwing it into Henry's car during the employee lunch hour.
Pete's new best friend, Alan, was married to Smackey Dog Food, Inc.'s owner, Kim, 4 years ago. Alan is also good friends with the banker from whom Sarah is seeking the loan. Pete is unaware of the relationship. Pete has talked about some of the details of the audit to Alan over a few beers.
K E Y P L A Y E R S
Pete, Audit Manager
Pete has been with your firm since you left Arthur Anderson pre-Enron. He was your staff auditor when you were an audit manager with AA and you brought him along for the ride. Pete hopes to be promoted to partner in the next year.
Ben, Audit Staffer
Ben has been with your firm since he graduated last year. He is easily distracted but puts in the long work hours necessary to build the firm's practice. Ben develops a crush on Smackey Dog food, Inc.'s bookkeeper Anita. He doesn't act on his feelings and does not mention this to anyone affiliated with the audit. You find out about it the following summer when he brings her to the firm's company picnic.
Maureen, Audit Staffer
Maureen has 5 years of prior experience as an auditor. She has a tendency to over audit accounts and needs supervision in this regard. Last year, she was responsible for catching a significant defalcation in the books of another client resulting in a federal investigation and incarceration of the client's CFO and a board member.