1. Discuss how QuickBooks can ensure a company is compliant with payroll taxes. Is there a difference between manual payroll and online payroll in QuickBooks? What are the company’s expectation for reporting payroll
2. What important feature in QuickBooks is used to create a new company and what does it entail? When are customers, vendors, and item lists added in the process?
In: Operations Management
Exercise 6-21 Complete the accounting cycle using inventory transactions (LO6-2, 6-3, 6-5, 6-6, 6-7)
Skip to question
[The following information applies to the questions displayed below.]
On January 1, 2021, the general ledger of Big Blast Fireworks includes the following account balances:
| Accounts | Debit | Credit | ||||
| Cash | $ | 24,500 | ||||
| Accounts Receivable | 43,000 | |||||
| Allowance for Uncollectible Accounts | $ | 2,900 | ||||
| Inventory | 43,000 | |||||
| Land | 81,100 | |||||
| Accounts Payable | 28,700 | |||||
| Notes Payable (6%, due in 3 years) | 43,000 | |||||
| Common Stock | 69,000 | |||||
| Retained Earnings | 48,000 | |||||
| Totals | $ | 191,600 | $ | 191,600 | ||
The $43,000 beginning balance of inventory consists of 430 units, each costing $100. During January 2021, Big Blast Fireworks had the following inventory transactions:
| January | 3 | Purchase 1,150 units for $121,900 on account ($106 each). | ||
| January | 8 | Purchase 1,250 units for $138,750 on account ($111 each). | ||
| January | 12 | Purchase 1,350 units for $156,600 on account ($116 each). | ||
| January | 15 | Return 165 of the units purchased on January 12 because of defects. | ||
| January | 19 | Sell 3,900 units on account for $624,000. The cost of the units sold is determined using a FIFO perpetual inventory system. | ||
| January | 22 | Receive $573,000 from customers on accounts receivable. | ||
| January | 24 | Pay $380,000 to inventory suppliers on accounts payable. | ||
| January | 27 | Write off accounts receivable as uncollectible, $2,200. | ||
| January | 31 | Pay cash for salaries during January, $132,000. |
The following information is available on January 31, 2021.
Exercise 6-21 Part 7
7. Analyze how well Big Blast Fireworks’ manages its inventory:
a-1. Calculate the inventory turnover ratio for
the month of January. (Round your final answer to 1 decimal
place)
a-2. If the industry average of the inventory
turnover ratio for the month of January is 13.2 times, is the
company managing its inventory more or less efficiently than other
companies in the same industry?
multiple choice 1
More
Less
b-1. Calculate the gross profit ratio for the
month of January. (Round your final answer to 1 decimal
place)
b-2. If the industry average gross profit ratio
is 33.0%, is the company more or less profitable per dollar of
sales than other companies in the same industry?
multiple choice 2
More
Less
c. Is the company’s strategy to sell a
higher volume of less expensive items or does the company
appear to be selling a lower volume of more expensive
items?
multiple choice 3
Higher volume of less expensive
Lower volume of more expensive
In: Accounting
Orange Company:
Wages paid to employees $15,000
Taxes paid to government $ 5,000
Sales revenue:
Oranges sold to public $10,000
Oranges sold to Juice Corp. $25,000
Orange Juice Company:
Wages paid to employees $10,000
Taxes paid to government $ 2,000
Juice boxes imported from China $ 1,000
Oranges purchased from orange corp. $25,000
Sales revenue $40,000
In: Economics
A Company is selling two products A and B. It sells the two products at the prices of AED 190 and 230 respectively. The finance department estimated the fixed cost for both products A and B as AED 2400 and 2550 and the variable cost to make a unit of each product is AED 70 and 60 respectively.
If the company used new technology in redesigning product A and the total fixed cost reduced to AED 2250. The marketing department estimated the new selling price per unit to be AED 240 and that the company would be break-even if they sale 10 units of product A. Compute the variable cost per unit and the total variable cost of the newly designed product A?
In: Finance
Orange Company:
Wages paid to employees $15,000
Taxes paid to government $ 5,000
Sales revenue:
Oranges sold to public $10,000
Oranges sold to Juice Corp. $25,000
Orange Juice Company:
Wages paid to employees $10,000
Taxes paid to government $ 2,000
Juice boxes imported from China $ 1,000
Oranges purchased from orange corp. $25,000
Sales revenue $40,000
In: Economics
Problem 2-19 (Algo) Multiple Predetermined Overhead Rates; Applying Overhead [LO2-1, LO2-2, LO2-4]
High Desert Potteryworks makes a variety of pottery products that it sells to retailers. The company uses a job-order costing system in which departmental predetermined overhead rates are used to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Molding Department is based on machine-hours, and the rate in the Painting Department is based on direct labor-hours. At the beginning of the year, the company provided the following estimates:
| Department | |||||||
| Molding | Painting | ||||||
| Direct labor-hours | 30,500 | 59,400 | |||||
| Machine-hours | 87,000 | 34,000 | |||||
| Fixed manufacturing overhead cost | $ | 295,800 | $ | 599,940 | |||
| Variable manufacturing overhead per machine-hour | $ | 2.20 | - | ||||
| Variable manufacturing overhead per direct labor-hour | - | $ | 4.20 | ||||
Job 205 was started on August 1 and completed on August 10. The company's cost records show the following information concerning the job:
| Department | |||||||
| Molding | Painting | ||||||
| Direct labor-hours | 77 | 130 | |||||
| Machine-hours | 340 | 74 | |||||
| Direct materials | $ | 948 | $ | 1,160 | |||
| Direct labor cost | $ | 720 | $ | 960 | |||
Required:
1. Compute the predetermined overhead rates used in the Molding Department and the Painting Department.
2. Compute the total overhead cost applied to Job 205.
3-a. What would be the total manufacturing cost recorded for Job 205?
3-b. If the job contained 30 units, what would be the unit product cost?
In: Accounting
Using a regression model in excel to understand the factors that contribute to customer satisfaction and spending. Refer to the data provided to identify what variables are significant to predicting overall satisfaction. Develop and interpret the prediction equation and the coefficient of determination. Based on the data, what areas should the business focus on to improve customer satisfaction?
| Dine In (1)/Take Out (2) | Satisfaction with Service | Satisfaction with Food | Overall Satisfaction | Driving Distance to Restaurant | Total Bill |
| 1 | 4 | 4 | 4 | 5 | 10 |
| 1 | 2 | 3 | 3 | 5 | 15 |
| 1 | 3 | 3 | 3 | 10 | 10 |
| 1 | 5 | 5 | 5 | 12 | 15 |
| 2 | 3 | 4 | 3 | 10 | 25 |
| 2 | 2 | 4 | 3 | 15 | 25 |
| 2 | 3 | 4 | 3 | 10 | 26 |
| 1 | 4 | 3 | 3 | 16 | 27 |
| 2 | 3 | 3 | 3 | 2 | 25 |
| 1 | 2 | 3 | 2 | 10 | 26 |
| 2 | 1 | 3 | 2 | 15 | 20 |
| 2 | 2 | 2 | 2 | 10 | 20 |
| 1 | 5 | 4 | 4 | 12 | 20 |
| 1 | 4 | 5 | 4 | 16 | 20 |
| 1 | 4 | 5 | 4 | 18 | 20 |
| 1 | 3 | 4 | 3 | 20 | 27 |
| 1 | 4 | 3 | 4 | 18 | 28 |
| 2 | 3 | 4 | 3 | 20 | 28 |
| 2 | 3 | 4 | 3 | 16 | 28 |
| 1 | 4 | 5 | 4 | 7 | 12 |
| 2 | 4 | 5 | 4 | 9 | 20 |
| 1 | 2 | 3 | 3 | 10 | 24 |
| 2 | 3 | 5 | 4 | 6 | 26 |
| 2 | 3 | 4 | 3 | 10 | 28 |
| 1 | 3 | 4 | 3 | 9 | 27 |
| 2 | 4 | 5 | 4 | 8 | 24 |
| 2 | 3 | 3 | 3 | 10 | 22 |
| 1 | 4 | 4 | 4 | 6 | 23 |
| 2 | 3 | 4 | 4 | 10 | 25 |
| 1 | 4 | 5 | 4 | 10 | 20 |
| 2 | 2 | 3 | 2 | 15 | 20 |
| 2 | 2 | 2 | 2 | 16 | 20 |
| 1 | 4 | 4 | 4 | 18 | 20 |
| 2 | 3 | 2 | 3 | 16 | 20 |
| 2 | 3 | 3 | 3 | 14 | 25 |
| 1 | 3 | 3 | 3 | 20 | 22 |
| 1 | 3 | 3 | 3 | 16 | 23 |
| 1 | 4 | 5 | 4 | 17 | 28 |
| 2 | 3 | 3 | 3 | 16 | 23 |
| 2 | 3 | 4 | 3 | 5 | 15 |
| 1 | 4 | 4 | 4 | 10 | 28 |
| 2 | 3 | 3 | 3 | 6 | 24 |
| 2 | 2 | 3 | 2 | 10 | 27 |
| 1 | 3 | 3 | 3 | 6 | 26 |
| 2 | 4 | 4 | 4 | 7 | 28 |
| 1 | 2 | 3 | 2 | 6 | 24 |
| 2 | 4 | 5 | 4 | 8 | 22 |
| 1 | 4 | 5 | 4 | 6 | 23 |
| 1 | 5 | 5 | 5 | 8 | 20 |
In: Statistics and Probability
Question 2: Preparation and Presentation of the Income Statement
SHOW YOUR WORKING FOR EACH OF THE NUMBERED QUESTIONS
In your new position as chief financial officer for Gulf Barges Limited, the first task you have been assigned to complete is to prepare the income statement for the 12-month period ended June 30, 2022.
On your desk on your first day, the previous chief financial officer has left you valuable information to complete the task.
SHOW YOUR WORKING FOR EACH OF THE NUMBERED QUESTIONS
1 -Total revenue recorded by Gulf Barges Limited during the accounting period was $185,852,000. Included in the total revenue figure is Other Revenue totalling $21,050,000 and Interest Income totalling $2,453,000.
Following is a list of expenses incurred by the company.
|
Expense Account |
Total Incurred |
|
Advertising and Marketing Costs |
$2,512,000.00 |
|
Assigned Overhead |
$15,483,000.00 |
|
Direct Labour |
$47,894,000.00 |
|
Direct Material |
$12,560,000.00 |
|
Entertainment |
$561,000.00 |
|
Insurance and Utilities |
$1,690,000.00 |
|
Office Supplies |
$590,000.00 |
|
Repairs and Maintenance |
$1,457,000.00 |
|
Salaries to Administrative Staff |
$6,801,000.00 |
|
Sales Commissions |
$21,036,000.00 |
|
Travel Costs |
$1,260,000.00 |
2 -On January 1, 2022, the company sold a block of land held for investment and recognized a gain on the sale of $12,861,000.
3 -On April 1, 2022, the company sold equipment that resulted in a loss of $4,891,000.
4 -The company incurred finance interest charges during the accounting period of $14,890,000.
5 -The company is involved in joint venture operations. As a result of poor financial conditions, the company recorded a net loss of $15,069,000 from its share of the joint venture operations.
6 -From the operations of its associate firms, the company recorded a net gain of $4,287,000 for the financial period ended June 30, 2022.
7 -If the company reports a profit during the year, the effective corporate tax rate is 25%. If a loss is reported the effective tax rate is zero.
Required:
Using the information supplied, prepare an income statement for Gulf Barges Limited for the accounting period that conforms with IFRS IAS 1 requirements and recommendation. (Hint: Expenses should be classified by function (e.g., cost of goods sold) not nature. SHOW YOUR WORKING FOR EACH OF THE NUMBERED QUESTIONS
In: Finance
Provide journal entries to following question
Problem 11-4A (Part Level Submission)
On January 1, 2018, Crown Point Ltd., a private company, had the following shareholders’ equity accounts:
| Preferred shares, $1 noncumulative, unlimited number authorized, none issued | ||
| Common shares, unlimited number authorized, 2.80 million issued | $2,800,000 | |
| Retained earnings | 3,900,000 |
The following selected transactions occurred during 2018:
| Jan. | 2 | Issued 210,000 preferred shares at $25 per share. | |
| Feb. | 8 | Issued 100,000 common shares in exchange for land. On this date, the current value of the land was $206,000. The common shares have not recently traded, but the last time they traded, they sold for $2.50 per share. | |
| Mar. | 5 | Declared the quarterly cash dividend to preferred shareholders of record on March 20, payable April 2. | |
| Apr. | 18 | Issued 426,000 common shares at $3.00 per share. | |
| June | 5 | Declared the quarterly cash dividend to preferred shareholders of record on June 20, payable July 1. | |
| Sept. | 5 | Declared the quarterly cash dividend to preferred shareholders of record on September 20, payable October 1. | |
| Oct. | 4 | Issued 41,000 preferred shares at $25 per share. | |
| Dec. | 5 | Declared the quarterly cash dividend to preferred shareholders of record on December 20, payable January 1. | |
| 14 | Declared a cash dividend of $0.50 per share to the common shareholders of record on December 31, payable January 10. | ||
| 31 | Net income for the year was $1.05 million. |
In: Finance
4. Listed below are the combined city – highway fuel consumption ratings (in miles per gallons) for different cars measured in old rating system and cars in a new rating system introduced in 2008 (based on data from USA today). A. Construct a 90 percent confidence interval of the difference in the ratings of cars. (Use 3 decimal places) (10 pts) Old Rating: 16 18 27 17 33 28 33 18 24 19 18 27 22 18 20 29 19 27 20 21 New Rating: 15 16 24 15 29 25 29 16 22 17 16 24 20 16 18 26 17 25 18 19 B. Based on the interval is there a reason to believe that there is a difference in the ratings of the two cars? C. Is there any significant difference in the old and new ratings of cars? Use appropriate hypothesis test to answer this question.
In: Statistics and Probability