GULF COLLEGE – MUSCAT – SULTANATE OF OMAN UNDERGRADUATE COMPUTING PROGRAMME ACADEMIC YEAR: 2019-2020 FRONT COVER ASSIGNMENT Module Title: Enterprise Application Development Module Code: COIS51045 Method of Assessment : PRACTICAL SQL TIMED TASKS Weighting: 20% Module Credits: 30 Level: 5 Semester/Teaching block: 2 Morning-Sess

[Type your answer. Hand-written answer is not acceptable.]1.  (20 pts) Given the following BANKING database, formulate a Relational Algebra expression for each of the following questions. SELECT should be performed before any JOIN operation. Notation: use the symbol S for SELECT, P for PROJECT, J for INNER JOIN, * for NATURAL JOIN,&n

Description The goal of this assignment is to create a re-usable Card and Deck class. This assignment will lead into Assignment 3 where you will build more classes to flesh out a card game. Use the following Guidelines: e Give identifiers semantic meaning and make them easy to read (examples numStudents, grossPay, etc). e Keep identifiers to a reasonably short length. e User uppe

Design and implement a Karaoke application which allows searching a large number of songs by title and adding songs to a ‘play-list’. When playing it should play the video of the songs in the play-list in order. You should consider the most appropriate data structure(s) and algorithm(s) to implement these features. Your design, including analysis of the time complexity of your solution, will b

College of Technological InnovationSEC435: Digital Forensics FoundationsCourse Project (25%)Investigate a topic on digital forensics similar to the one listed below, then submit a report. Investigate a topic on digital forensics:Identify a topic of your interest, a sample list is shown below, the task is to explore the selected topic from various aspects and present the finding and acquired k

Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $30 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to

The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Total Dirt Bikes Mountain Bikes Racing Bikes Sales $ 925,000 $ 267,000 $ 406,000 $ 252,000 Variable manufacturing and selling expenses 466,000 118,000 196,000 152,000 Contribution margin 459,000

Direct Labor Variances Bellingham Company produces a product that requires 10 standard hours per unit at a standard hourly rate of $10.00 per hour. If 2,300 units required 23,900 hours at an hourly rate of $10.20 per hour, what is the direct labor (a) rate variance, (b) time variance, and (c) total direct labor cost variance? Enter a favorable variance as a negative number using a minus sig

Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated based on their own division’s return on investment (ROI). Assume the following information relative to the two divisions: Case 1 2 3 4 Alpha Division: Capacity in units 51,000 288,000 102,000 202,000 Number of units now being sold to outside customers 51,000 288,000 7

need the correct answer Saved Chapter 10- Homework 1 Requiieu momauun Use the following information for the Exercises below. [The following information applies to the questions displayed below.] Ramirez Company installs a computerized manufacturing machine in its factory at the beginning of the year at a cost of $84.200. The machine's useful life is estimated at 20 years, or 391,000 units of p

Sako Company’s Audio Division produces a speaker that is used by manufacturers of various audio products. Sales and cost data on the speaker follow: Selling price per unit on the intermediate market $ 47 Variable costs per unit $ 20 Fixed costs per unit (based on capacity) $ 8 Capacity in units 60,000 Sako Company has a Hi-Fi Division that could use this speaker in one of

ABC Company's record of transactions for the month was as follows: Purchases April 1 (current balance) - 230 @ 5.40 April 4 - 530 @ 5.51 12 330 April 11 - 430 @ 5.72 27 1,060 April 18 - 330 @ 5.78 28 150 April 26 - 730 @ 6.05 April 30 - 330 @ 6.26 Sales April 5 - 430 April 12 - 330 April 27 - 1,060 April 28 - 150 1) Calculate average cost per unit assuming perpetual inventory records are kept in u

The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 990,000 $ 49.50 Variable expenses 594,000 29.70 Contribution margin 396,000 19.80 Fixed expenses 318,000 15.90 Net operating income 78,000 3.90 Income taxes @ 40% 31,200 1.56 Net income $ 46,800 $ 2.34 The company had average operating assets of $505,

Answer 1,2,3,4,5 The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Demand Selling Next Price Direct Materials Labor $5.50 $2.30 $8.24 $3.20 year Product (units) 62

Dorsey Company manufactures three products from a common input in a joint processing operation. Joint processing costs up to the split-off point total $315,000 per quarter. For financial reporting purposes, the company allocates these costs to the joint products on the basis of their relative sales value at the split-off point. Unit selling prices and total output at the split-off point are a

The following selected transactions were completed during March of the current year: March 1 Billed customers for fees earned, $54,100. 4 Purchased supplies on account, $1,250. 8 Received cash from customers on account, $43,800. 11 Paid creditors on account, $600. Required: A. Journalize these transactions in a two-column journal. Refer to the list of accounts in the T accounts for exact wording o

Need help computing LIFO and Average cost Requirements 1, 2, and 3. Compute cost of goods sold and gross profit using FIFO, LIFO, and average cost methods. (Round the average cost per unit to the nearest cent and all other amounts to the nearest dollar.) FIFO LIFO 9,632 Sales revenue 5,615 Cost of goods sold $ Gross profit 4,017 38 tires @ $ Beginning inventory 130 16 tires @$ Purchase.. 135 43

Rexble Overhead Budget Lene Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 11,000 hours of productive capacity in the department Variable overhead cost Indirect factory labor $86,900 Power and light 4,620 Indirect materials 25,300 Total variable overhead cost $116,820 Fxed

Quantity Date Item Unit Cost 12 $ 1 Balance Oct 265 5 Sale 15 $ 12 Purchase 271 21 Sale 30 Sale 7 LO Requirement 1. Compute the cost of goods sold under FIFO. Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record

Johnson, Inc. has collected the following data for November (there are no beginning inventories): E(Click the icon view the data.) Read the requirements. X iRequirements Requirement 1. Using absorption costing, calculate the unit product cost (Round your final answer to the nearest cent.) Absorption 1. Using absorption costing, calculate the unit product cost. 2. Prepare an income staterment usin